OpenAirDocs.org
AD 2012-11-06

Registered aircraft · 84

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-06')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N461ARSolo Energy Drink Inc · Miramar, FLFirst renewal noticeS/N 384N467AMBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 441N478VTTipnes Aviation LLC · Tampa, FLBuilt 1981 · S/N 308N492AN492a LLC · Gilbert, AZBuilt 1984 · S/N 425N501JVJetvue Texas LLC · Richardson, TXBuilt 1982 · S/N 373N50BHTravel Link LLC · Vienna, VABuilt 1982 · S/N 359N510FROneflight International Inc · Englewood, COBuilt 1984 · S/N 446N520NANasa Langley Research Center · Hampton, VAS/N 86-0206N53KWWiley Bob Inc Trustee · Troy, ALS/N 028N540EALastra Air Cargo Express · Saint Petersburg, FLS/N 174N550JFTs Aviation LLC · New York, NYBuilt 1985 · S/N 472N555DWInstitue Of Aeronautical And Aerospace Institute · Aguadilla, PRBuilt 1985 · S/N 459N608BGN A S A Lyndon B Johnson Space Center · Houston, TXS/N 430N710CFCalspan Corp · Niagara Falls, NYBuilt 1984 · S/N 448N711UFDodson International Parts Inc · Rantoul, KSBuilt 1984 · S/N 421N714DSPhoenix Air Group Inc · Cartersville, GAS/N 488N721CFCalspan Corp · Buffalo, NYBuilt 1984 · S/N 429N721CNUnited Trading Unlimited LLC · Coconut Grove, FLS/N 206N748MNOnpoint Avionics LLC · Downey, CAFirst renewal noticeBuilt 1977 · S/N 215N74AMissile Defense Agency (Mda) · Tulsa, OKBuilt 1968 · S/N 36N74RTState Technical College Missouri · Linn, MOS/N 219N774MBVida Trade And Management Group · Charlotte, NCS/N 339N779LCTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1970 · S/N 88N804NANasa Neil A Armstrong Flight Research Center · Edwards, CAFirst renewal noticeBuilt 1982 · S/N 344N808NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1984 · S/N 424N818VBPhoenix Air Group Inc · Cartersville, GABuilt 1980 · S/N 302N828AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 415N857PRTravel Link LLC · Vienna, VAS/N 348N888WEPrime Aircraft & Aviation LLC · Edmond, OKS/N 394N892QMMedina Iran · North Bay Village, FLS/N 078N945PKArchangel Operations LLC · Lewes, DEBuilt 1975 · S/N 165N946NANational Aeronautics And Space Administration · Houston, TXBuilt 1974 · S/N 146N975RGRg Aviation LLC · Fort Lauderdale, FLS/N 471N992NANational Aeronautics And Space Administration · Houston, TXBuilt 1980 · S/N 309
Back to AD 2012-11-06