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.
N7238EStevenson Bill · Sunrise Beach, TXN7238NKietzer Rocklyn D · Hartford, MIN72395Orion Works Ltd · Denali Park, AKN7239NSea Island Skies LLC · Ponte Vedra Beach, FLN723CSFinch Dennis G Jr · Long Prairie, MNN723DMCaswell & Sons LLC · Belmont, NCN723FClear Skies LLC · Stuart, FLN723NETaft Millens W III Trustee · Wilton, CTN723SEFrost Cavin Bert · Odessa, TXN723SSTomlinson Jason R · Lake Jackson, TXN72412Intricate Bay Operating LLC · Saylorsburg, PAN7241SWatrous David S Trustee · Gainesville, VAN7242ES S Farms Of Freeborn County Inc · Albert Lea, MNN7244ETomsheck Matthew E · Seville, OHN7245EWheeler Chad L Personal Representative · Arco, IDN7247EStrong Brian S · Southport, NCN7247NMartin Christian E · Amagansett, NYN7248ESchutt Patrick M · Kingsville, MON7249SBell Global Security Group LLC · Lewes, DEN724DBRegistered aircraftN724EWVan Bortel Aircraft Inc · Arlington, TXN724RJRehkopf Ronald O · Texarkana, TXN724TMiller Neil · Plymouth, MNN725Butler Harris K III · Towanda, KSN7250NSimon Jevon · Buckley, WAN7251EFord Michael G · Doerun, GAN7251NThornton Chad · Seattle, WAN7252SDorris Joseph · Lewisburg, KYN7254HVevani Aircraft LLC · Miami Gardens, FLN7254NChoice Aviation LLC · Hamilton, MTN72559Welch Paul · Oldsmar, FLN7255EValley Pilots Flying Club Inc · Martinez, CAN7256GAvstar Inc · Seattle, WAN7256HChaparral Aviation LLC · Edmond, OKN7256QAustin Ferrel Stephen · West Monroe, LAN7256WRoswall James B · Bristol, TNN7256YGupta Vivek · Shelton, CTN7257NPeterson Winston Roy II · Arbuckle, CAN7259EWiley Jerry Lynn · Mission, TXN7259GLuevano Eric · Huntington Beach, CAN725ASGeorgia Co Of Aspiring Flyers LLC · Clarkesville, GAN725BJBas Part Sales LLC · Greeley, CON725VPTeam Negrich LLC · Osteen, FLN7260HN2617f LLC · Frankfort, KYN7260KAmbitious Aviation LLC · Newport News, VAN7260QNaples Flying Club Inc · Naples, FLN72612Washington State Dept Of Transp · Tumwater, WAN72614Liberty Leasing IV LLC · Melbourne, FLN7261HMurray John Fulton III · Fort Worth, TXN7261MCox Jeff C · Newark, OH
Back to AD 84-10-01 R1