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.
N37CJFly172s LLC · Peoria, AZN37CPRegistered aircraftN37DAero Equities LLC · Ventura, CAN37DKPreston Richard R Trustee · Albuquerque, NMN37DMWilliams Arzania S · Bolingbrook, ILN37DNAshmore Seth S · Scottsboro, ALN37EFProctor John · Rosebud, TXN37EGVolterra LLC · Iowa City, IAN37ELLee Ed C · Lancaster, SCN37EWKundel Andrew R · Muscatine, IAN37EZCaulkins John · Bay Village, OHN37FLN37fl LLC · Port Saint Lucie, FLN37GWillamette Valley Soaring Club · Beaverton, ORN37GGAvco Patrol LLC · Lyndon, KSN37GMCraft Engineering Associates Inc · Hampton, VAN37GWSale Reported · Webster, MNSale reportedN37HDJohnston-Matejek Aviation LLC · Houston, TXN37HMRegistration Pending · West End, NCRegistration pendingN37HYRegistration Pending · Wasilla, AKRegistration pendingN37JJMamuzich Robert J Jr · Ocala, FLN37JNWings As Eagles Mission Air Service Inc · Oshkosh, WIN37JSNewton Wm L · China Spring, TXN37KBMccraw Michael · Myakka City, FLN37KFFillips Karl · Alvin, TXN37LMMay Richard A · Fort Mill, SCN37LVLegros Aviation Services Inc · Crowley, LAN37MAAndorfer Micheal T · Fort Valley, GAN37MCTvb Aviation LLC · Mcallen, TXN37MFMueller Martin S · Coeur D Alene, IDN37MGWood Ronald G · Weatherford, TXN37MJLara-Meza Sergio Giovanni · Mcallen, TXN37MKSkyhoundmedia Inc · Royal Oak, MIN37MLLacher Meldon J · El Cajon, CAN37MTBeaver Valley Flying Club Inc · Beaver Falls, PAN37MVMonreal Michael · North Barrington, ILN37MZHamm George W Trustee · Fort Worth, TXN37NCGlace Charles L · Spartanburg, SCN37NERotor Technologies Inc · Nashua, NHN37NHLfs Inc · Ekalaka, MTFirst renewal noticeN37PVan De Pol John M · Amherst, TXN37PAThree Rivers Aero LLC · Three Rivers, MIN37PB37pb Inc · Seattle, WAN37PKThill James L · Leesburg, VAN37PMRegistered aircraftN37PRS & R Planes LLC · Tulsa, OKN37RAGustafson John A Trustee · Boulder City, NVN37RCCorrao Robert F Jr · Scottsdale, AZN37RFAdams Aviation Services Inc Trustee · Wilmington, DEN37RHRegistered aircraftN37RKWardrop Donald Alexander · Bay Springs, MS
Back to AD 2007-04-19 R1