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.
N484JLAustin Peay State University · Clarksville, TNN484JRC L Farwell Holdings III LLC · Brookline, NHN484JWAims Community College · Greeley, CON484KWNunez-Fontes Fernando · Rio Rico, AZN484MLLoree Steve J · Placerville, CAN484NDUnd Aerospace Foundation · Grand Forks, NDN484PPrickett Jonathan L · Austin, TXN484SHNovember Alpha LLC · Dover, DEN484SWElsass Aviation LLC · Fayetteville, ARN484TCTrl Aviation LLC · Wichita, KSN484VMLake John K · Park City, UTN484WBRegistration Pending · Kansas City, MORegistration pendingN485Obenchain David W · Simi Valley, CAN4850BRoehrig James R Jr · Indianapolis, INN4850GPeters Walter C · Rockford, ILN4850JCardamone Rayner Mark Gibson · Manistique, MIN4850LUpper Airway Aviation LLC · Sonora, CAN4850URegistration Pending · Elsie, MIRegistration pendingN4851GEye Candy Aviation LLC · Jacksonville, FLN4851JAbernathy Spraying Service Inc · Tipton, OKN4851LCherokee Flyers LLC · Randolph, WIN4851PTwin Air Assets LLC · Casper, WYN4851TWillis Gary B · Willis, TXN4852AHanrahan Andrew D · Soldotna, AKN4852ESproul David Douglas Jr · Heath, TXN4852GR&R Aero Services LLC · Eden Prairie, MNN4852JStoffel Christopher David · Colorado Springs, CON4852LMohle Darren H · Carlsbad, CAN4852TDeloach Stephen T · Brentwood, TNFirst renewal noticeN4852VR & R Aviation Services LLC · Darien, ILN4853Stoltz Michael A · Portland, ORN4853CIdaho Flying Service LLC · Kamiah, IDN4853DCrosgrove Shawn R · Riverton, UTN4853JNaca 130 LLC · Cameron Park, CAN4853PSwan Aviation Ministries Inc · Baker, FLN4854GMilwaukee Aero LLC · Milwaukee, WIN4854JTrio Bravo Ltd · Hudson, OHN4854LBarnes Doyle W · Glen Carbon, ILN4854RFisher Ag Service LLC · Cardington, OHN4854URieser Donald E · Antioch, ILN4854XGrundmeier Patrick B · Gilbert, AZN4855CFoss James K · Anchorage, AKN4855DRegistration Pending · Peachtree City, GARegistration pendingN4855GWings Over Texas Holdings LLC · Denton, TXN4855LEagle Sky Patrol Inc · Deadwood, SDN4855TVaitai Rei LLC · Spring, TXN4855VGlide Slope Aviation Inc · Myakka City, FLFirst renewal noticeN4856AManning Travis J · Reno, NVN4856DOlsen Ernest D · Lino Lakes, MNN4856GNatchez Flight Training LLC · Natchez, MS
Back to AD 2007-04-19 R1