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.
N57343Arrow Plane Inc · Chapel Hill, NCN57346Cohen Meaghan M · Edgemere, MDN57347Burmaster Gary S · Rancho Murieta, CAN5734BGrinnell Chris · Willis, TXN5734UPiepenbrink Stephen J · Wichita, KSN5734VAranda Carlos Javier · Orange, CAN57350G F Aviation Inc · Miramar, FLN57352Dewalt Colt Aerospace LLC · Logan, OHN57353Registration Pending · Hollister, MORegistration pendingN57358Farnsworth Philo L Trustee · Dunes City, ORN5735PPlanecrazyd LLC · Portal, GAN5735QBeler Arnold Ray II · Redlands, CAN5735VRay Brian · Peoria, ILN5735WMorahan Mark A · Sandusky, OHFirst renewal noticeN57360Ranuio Julie V · Ramona, CAN57361Janusz Mika · Phoenix, AZN57364Fit Fliers LLC · Worcester, MAN57369Fahmy Bishoy · Fraser, MIN5736QWard Troy · Odessa, TXN5736UWunder Bernard A · Lusby, MDN5736VLom-Ajan Vicente A · Plantation, FLN5736WTime Flyer LLC · Kalispell, MTN57370Nj Aviation LLC · Forest, VAN57371Morgan H Owen · Windsor, CON57378Darling Darrin D · Palm Desert, CAN57379Faison Alphonso Trustee · Gardena, CAN5737JSkolnik Adam R · Clermont, FLN5737KNeubauer Accounting LLC · Wray, CON5737QBross Stephen W · Burke, VAN5737UStebbins A C · Tacoma, WAN5737WUltimate Airparts LLC · Strasburg, VAN57385Victor Foxtrot LLC · Scott City, KSN57386Arair LLC · Kindred, NDN5738QGuillen Gregorio J · Lopatcong, NJN5738UFlorida Time Building LLC · Port Saint Lucie, FLN5738VBailey Frederick D · Fayetteville, ARN5738WCherokee 38whiskey LLC · Charlotte, NCN57390Beyer Mark E · Towanda, KSN57394Mccombs Evan · Peyton, CON57395Zangs William J · Poplar Grove, ILN57399Aerobatic 8kcab Holdings LLC · Murchison, TXN5739DSmith James A · Lyle, WAN5739KLyn Alden Cleveland · Kansasville, WIN5739QMorell Timothy S · Lino Lakes, MNN5739WFeralova Erika H · Gresham, ORN573ATAtp Aircraft 3 LLC · Wilmington, DEN573CBMussell Lincoln D · Longview, TXN573CDF R E Investments LLC · Enterprise, ALN573ELStellaire Alliance LLC · Fort Worth, TXN573JAYale Companies LLC DBA · Fishers, IN
Back to AD 2007-04-19 R1