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.
N64251Gilliland Brothers Drayage LLC · Farmington, UTN64257Lutes Ralph E · Shipshewana, INN6425XGary Equipment Leasing LLC · Oscoda, MIN6426AAmes Todd · Millington, MIN6426TS O W Aviation LLC · Crystal River, FLN6426XBenedict Brandon M · Anchorage, AKN6427XBuck Timothy A · Howland, MEN6428ZDv Aviation Inc · Brainerd, MNN642ABauer Thomas M · Elizabethtown, KYN642WRN642wr LLC · Henderson, NVN6430ATulsa Technology Center School District No 18 · Tulsa, OKN6430XLegner Leasing LLC · Las Vegas, NVN6431NMorton Craig Allister · Toluca Lake, CAN64337Clearwater Airco LLC · Anchorage, AKN6433AWagar Dennis Murphy · Marion, MTN6433TCole Richard J · Rolla, MON6433XRand Carl · Durango, CON6434NDecker Rufus G III · Arlington, VAN6434RCutlass Aviation LLC · Auburn, ALN6436BConway Jenna M · Camarillo, CAN6437ATwin Oaks Aircraft Maintenance LLC · Hillsboro, ORN64382Roost Leasing LLC · Sturgis, MIN6438AP M Leasing Inc · Perris, CAN6439NSpectraq LLC · Las Vegas, NVN643CPCivil Air Patrol · Maxwell Afb, ALN643GWFoxtrot93 Holdings LLC · Wilmington, DEN643PEColiseum Aviation LLC · Little Rock, ARN643UFRegistered aircraftN-number assigned (import), not yet registeredN644Wine Street Aviation LLC · Livermore, CAN6440BWolfe Transportation Inc · Meridian, IDN6440YTamarack Graphics LLC · Salt Lake City, UTN64426Brook Trout Air LLC · Cle Elum, WAN6442ABalderston Jessika A · Ronan, MTN6442YPouppeville LLC · Tulsa, OKN6443AStartin Matthew R · Colfax, WAN6443NEwers Richard G · Indio, CAN6443XGibbins Brett S · Mc Grath, AKN6444MMccoy Thomas F · Sperry, OKN6444TYankee Flying Club Inc · Maple Grove, MNN6445YRomero Bernard L · Santa Fe, NMN6447ACouch Andrew W · Newport Beach, CAN6447XSteller Air Service LLC · Homer, AKN6449HN6449h LLC · Pompano Beach, FLN644CPCivil Air Patrol · Maxwell Afb, ALN644CTC323 Holdings LLC · La Grange, TXN644FMHolby Eric · Breckenridge, CON6450XLayman James D · Eagle, AKN6450YAttica Flyers Inc · Lafayette, INN64529Stallion 51 Corp · Kissimmee, FLN6452ARansom Bradley D · Flagstaff, AZ
Back to AD 84-10-01 R1