Registered aircraft · 909

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

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:98-05-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-05-14-R1') ORDER BY n_number

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:98-05-14-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-05-14-R1')
  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.

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:98-05-14-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-05-14-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1003AOakshire Aviation LLC · Yakima, WABuilt 1978 · S/N P21000078 N100DBState Of Wisconsin · Madison, WIBuilt 1980 · S/N 21063970 N1011Martin Rex L Trustee · Bakersfield, CABuilt 1980 · S/N 21064004 N1028RGarner Donald G · Greeley, COBuilt 1980 · S/N P210-00401 N102KYPatriot Aviation LLC · Rostraver Township, PABuilt 1978 · S/N P21000093 N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174 N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366 N10HXIjh Farm Inc · Seminole, TXS/N 21063588 N10TTHays John J Jr · Denton, TXBuilt 1978 · S/N P21000056 N110KMCars Planes And Land LLC · Fuquay Varina, NCBuilt 1983 · S/N 21064800 N111VFCottle John A DBA · Watsonville, CABuilt 1980 · S/N 21064005 N1123UTroy Investment Co 1 L P · Brownsville, TXBuilt 1982 · S/N 21064667 N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669 N113TTHaley John R · Tomball, TXBuilt 1979 · S/N P21000281 N1178UWaco Diamond Star LLC · Niceville, FLS/N 21064671 N117UMCn Aviation LLC · Gilbert, AZBuilt 1980 · S/N P21000530 N1199ULansford Inc · Clovis, NMBuilt 1982 · S/N 21064673 N11JJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000511 N120BCHunyadi James W · Toledo, OHBuilt 1979 · S/N P21000404 N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682 N128EEAlgab Holdings LLC · Newark, DEBuilt 1978 · S/N P21000133 N12JGVosworx Aviation LLC · Morrison, COBuilt 1979 · S/N P21000365 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065 N152BTCoho Aviation LLC · Hillsboro, ORBuilt 1980 · S/N P21000486 N155DGJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1983 · S/N 21064815 N155RCClark 155 LLC · Missoula, MTS/N 21064312 N15CWN15cw LLC · Wilmington, DEBuilt 1983 · S/N P21000824 N15MWZeezee LLC · Phoenix, AZBuilt 1978 · S/N 21063023 N1625UFly2k LLC · San Jose, CABuilt 1982 · S/N 21064710 N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724 N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725 N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460 N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169 N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101 N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807 N171BCR Wesley Aviation LLC · Chandler, AZBuilt 1981 · S/N 64251 N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894 N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735 N174SFTaylor Thomas R · Lenoir, NCBuilt 1978 · S/N P21000174 N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739 N177PEPicabo Livestock Co · Picabo, IDBuilt 1979 · S/N P21000334 N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744 N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445 N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296 N1968RCloud Transport Operations LLC · Albuquerque, NMS/N 21064375

Back to AD 98-05-14 R1