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.
N3034WMccall Freddie · Brewton, ALFirst renewal noticeN3034ZBrown Timothy M · Clyde, OHN30353Stracuzzi Charles J · Ocala, FLN30357Cammack Brian W · Edgewood, NMN3035DBeverly Flight Center LLC · Danvers, MAN3035FUtah State University · Logan, UTN3035NPs N3035n LLC · Green Bay, WIN3035WWorldwide Air & Sea Inc · Wilton, NHN3035YWardlaw Consulting LLC · Truckee, CAN30363Talbot Douglas J · Sandpoint, IDN3036CSimpkins Larry D · Williamson, WVN3036JSebring Aviation Of Highlands County Inc · Sebring, FLN3036Q3 Rivers Airshare Llp · Sheridan, MTN3036UCoronel Noel R · Clifton, NJN3036YPeterson Zachary E · Fargo, NDN3036ZAbell Alan R · Elgin, ILN30370Fellow Ship Aviation LLC · Monticello, GAN30374Canihan William R · Novato, CAN30378White George J Trustee · Apple Valley, CAN3037ENavy Annapolis Flight Center Inc · Edgewater, MDN3037FNulton Enterprises LLC · Johnstown, PAN3037QState Of Arizona · Holbrook, AZN3037UOpper Robert C · Willard, OHN3037ZDads Aviation Plans LLC · Wilmington, DEN30382Bird Victor Z · Surprise, AZN30385Auberge De Savoie Inc · Wilmington, DEN30387Watkins Bruce K · Houston, TXN3038FTaylor Spencer H · Lake City, FLN3038LRegion Flyers LLC · Valparaiso, INN3038NN3038n LLC · Lehi, UTN3038TNorth Shore Aero Club Inc · Beverly, MAN3038UVenbro Holdings LLC · Brooklyn, NYN3038ZFischer Mark D · Hooker, OKN30390Rimmer Nathan S · Seattle, WAN30393Graden Timothy J · Polo, ILN30396Sill John A · Cable, WIN30399Schwanke Donald D · Springfield, ILN3039CDammel Stanley J · Odessa, WAN3039DN3039d LLC · Saint Augustine, FLN3039FSilverhawk Aviation Academy LLC · Caldwell, IDN3039PScholz Rolf H · Columbus, INN3039SChaco John R · Bonita, CAN3039WDillon Mark A · Peoria, AZN3039ZSvec Adolph R · Marengo, ILN303ABMarc Inc · Bolton, MSN303ACUlinski Daniel J · Glen Burnie, MDN303APRegistered aircraftN303AVZachariah Jacob · West Palm Beach, FLN303BBPerry Clifton B · Lacon, ILN303BPMohan Anand · Vienna, VA
Back to AD 2007-04-19 R1