AD 84-10-01 R1
Registered aircraft · 20,483
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.
N3657YSims Daniel G · Martinez, CAN3658YJo Co Inc · Knoxville, TNFirst renewal noticeN3659CWhite Paul S · Clarksville, TNN3659YPeterson Laurel R · Hart, MIN365CACivil Air Patrol · Maxwell Afb, ALN365MADip Aviation LLC · Fort Lauderdale, FLN365MEEhnisz Craig T · Monterey, CAN365WCCrane Douglas F · Ukiah, CAN3661CAas LLC · Ovid, MIN3661TOmega 1 Corp · Middletown, DEN3661UGlenney Christopher · Milan, NHN3662CArmi LLC · Nevada, IAN3662UBenter Wayne D · Crosby, NDN3663UWilliams James R · Austin, TXN3663YBrown Robert Scott · Troutman, NCN3664UAir Skylane LLC · Boulder, CON3665CN3665c LLC · Otsego, MNN3665UBlue Skies Aviation Of Wi Inc · Pulaski, WIN3665YJ & B Airlift LLC · Rupert, IDN3666CStrauss Kenneth W · Vashon, WAN36674Brown Kile Executor · Dallas, TXN3667YAir Wake Aviation LLC · Hazelwood, MON3668CN3668c L L C · Depauw, INN366KWhite Thomas J · Agua Dulce, CAN366MATew Services Corp · Wilmington, DEN366METhree Six Six Mike Echo LLC · Mantua, UTN366NHState Of New Hampshire Dept Of Safety · Concord, NHN3670YRoussin David G · Newville, ALN3671CCharlie Aviation LLC · Philpot, KYN3672CWells William · Cary, NCN3672UD W Clark LLC · Newton, NJN3672YN3672y LLC · Ferrysburg, MIN3675CBergstrom Dean A · Watertown, CTN3675YShettle Jay E · Berryville, VAN3676CBoyce Walter Doug · Palmer, AKN3676UGregg Michael · Orlando, FLN3678UCaven Dennis L · Santa Rosa, CAN3678YDozier Zach J · New Boston, TXN3679UPowerhouse Coach Inc · Idaho Falls, IDN367CRRay Samuel · Spring Hill, TNN367TJFlorida Aerial Services Inc · Lutz, FLN3680CBindon Phil E · Wasilla, AKFirst renewal noticeN3681YJeff Blue Corp · Seminole, FLN3682CKiger Lance B · Prairieville, LAN3684CFly Away Aviation LLC · Folsom, LAN3684UToews Berton J · Casper, WYN3685YWhite Lawrence L III · La Habra, CAN3686CSedwick William R · Anchorage, AKN3686UEnvi Adventures LLC · Troutdale, ORN3686YEllis Air LLC · Acworth, GA
Back to AD 84-10-01 R1