AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N639CPCivil Air Patrol · Maxwell Afb, ALN63CEBarr Air Patrol LLC · Mesquite, TXFirst renewal noticeN63GWAtc 2 LLC · Post Falls, IDN63VTFlyways LLC · Bemidji, MNN63WSCooks Saw Manufacturing LLC · Newton, ALN63XYRegistered aircraftN64027Snyder Brent R · Dallas, TXN6402NManos Con Alas Aviation · Stateline, NVN64044Johnson Lance D · Duluth, MNN6404FHigh Demand Earthworks & Vineyard Development LLC · Napa, CAN6405XArctic Aviation Leasing LLC · Anchorage, AKN6406XIronsides Custom Grinding Inc · Waitsburg, WAN6408NBorders Nowell W · Edinburg, TXN64099Tullio John P · Edgewood, TXN6409YChino Aviation Inc · Chino, CAN640CPCivil Air Patrol · Maxwell Afb, ALN640SLKoonce Gary L · Midland, TXN64109Bickford Shawn A Trustee · Big Lake, AKN6410ANichols John W · Post Falls, IDN6410NAerial Services Inc · Cedar Falls, IAN6413XMeyer Charles H · Stratford, CAN64153Davies Thomas V · Chula Vista, CAN6415APekkala John W · Palmer, AKN6415FDewitte Jon James · Bishop, GAN6415XPogany Steve C · Chugiak, AKN64167Registered aircraftN6416AJanak Jeffrey · Corpus Christi, TXN6417ALevasseur Peter W · Plymouth, MEN6417NTaylor Michael Norman · Chino Hills, CAN64183Chiappe Glenn R · Lago Vista, TXN6418TRobo Flight Air Support LLC · Inver Grove Height, MNN6418XCoffman David W · Wilbur, WAN6419BMarshall Timothy M Trustee · Tucson, AZN6419XPernat Frank J Trustee · Chaska, MNN641ABDaccarett Marcos · Boise, IDN641JMDubose Mack H · Edmonds, WAN641MRoyo Marco · Canutillo, TXN641TAAk Leasing LLC · Orchard Lake, MIN64205Mulligan George G Trustee · Friday Harbor, WAN6420AAbidance Inc · Winthrop, WAN6420TJetran LLC · Horseshoe Bay, TXN6420XHarmon Jeremy Scott · Ely, MNN6420YFlying Amigos Aviation LLC · Las Cruces, NMN64211Miller Paul F · Whitefish, MTN6421AAllen Khaled Charles · Berkeley, CAN6421XDinstel Delbert F · Park City, MTN6421YHulett Gregory · Las Vegas, NVN6422AColby Clayton L · Kalispell, MTN6422XHawley Lorna M · East Troy, WIN6424XAbbott R Barry · Tempe, AZ
Back to AD 84-10-01 R1