AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N30900Pouilaitis William G · Landing, NJN30909Page Steven C · Porterville, CAN3090AFlight Training Aircraft LLC · Wilmington, DEN3090FAero Missions Inc · Birmingham, ALN3090PRegistered aircraftN3090RCasper Clarence Jr · Groton, CTN3090TBeech 3090t Inc · Midlothian, TXN3090YPine Tours LLC · Wilmington, DEN30918Duepner Greg D · Georgetown, TXN30919Callahan Aviation LLC · Clearwater, FLN3091APeltier Eric M · North Pole, AKN3091DBella Farms Inc · Hayes Center, NEN3091LAbbasi Babak · Murrieta, CAN3091QDank Noah S · Jacksonville, FLN3091TSutton Aircraft Salvalge LLC · Palmer, AKN3091UExaqt Consultant Group · Madison, ALN3091ZCheshier Elmer J · Cordova, AKN30925Davis Jerold W · Fallbrook, CAN30928Kellner Donald · Attica, NYN3092CAhmed Sharfaraz · Houston, TXN3092FJungemann Jon D · Victor, MTN3092TTango LLC · Quaker Hill, CTN3092WPrimm Daniel D Jr · Lexington, KYN3092XSilverhawk Aviation Academy LLC · Caldwell, IDN3092YGordon Robert A Jr · North Pole, AKN3092ZE & K Feeders Inc · Emmet, NEN30934Happy Bottom Flying Club · Griggsville, ILN30935Peterson Air LLC · Chisago City, MNN30936Wilcox Gary C · Dansville, MIN30938Virginia Aviation LLC · Forest, VAN30939Lee Richard B · Wasilla, AKN3093EBrown Joseph M · Kansas City, MON3093NRentfrow Christopher Michael · Rockwall, TXN3093QLitton Wade N · Townsend, MTN3093YRegistered aircraftN3093ZHall Wendell D · Upham, NDN30940Qualitair LLC Trustee · MicahelstadtN30941Clausnitzer Douglas L · Apple Valley, MNN30942Polar Bear Aviation LLC · Batesville, MSN30945Hawkins Cody · Englewood, CON30946Goldstein Jonathan D · Freehold, NJN3094CHamllin Jeffry S · Double Oak, TXN3094DAberdeen Pilots LLC · Boerne, TXN3094QSunrise Property Maintenance Inc · Sandy, UTN3094ZEspil John R · Lovelock, NVN30956Ought To Fly Inc · Litchfield, ILN3095CLittle Karley Y · Baytown, TXN3095DIrvine William G · Rosamond, CAN3095FGroebner David · Red Wing, MNN3095YBatenhorst Ag LLC · Dalhart, TX
Back to AD 2007-04-19 R1