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.
N33485Bruner Timothy R · Laurel, MDN33488Mcintyre William H · Waterloo, ALN3348TWarhol Peter J · Peever, SDN3348UCollins Christopher E · Bluford, ILN3348VSullivan Jon L · Lincoln, NEN3348WCyrus Ely G · Kiana, AKN3348YBlue Sky Flyers Inc · Punta Gorda, FLN33491Love Steven J · Rio, ILN3349ADoherty David R · Thief River Falls, MNN3349CCabrera John F · Glendale, CAN3349DWeninger Gregory M · Burrton, KSN3349FMaxfield David · Greenville, SCN3349JRegistration Pending · Quincy, OHRegistration pendingN3349MDunkley Bret Y · Kotzebue, AKN3349SJin Jin Aviation LLC · Anchorage, AKN3349TStuart John R · Taylorsville, KYN3349ZPorter Curtiss L · Woodscross, UTN334ABerry Darrel · Camden, TNN334ACRegistration Pending · Farmingdale, NYRegistration pendingN334AKJag Air Inc · Tampa, FLN334ARHouldson Consulting Inc · Morrison, ILN334AZCossette Brian J · Summerset, SDN334BWings Over La Aviation LLC · West Hills, CAN334BCJohnston John W · Sandia, TXN334BGBowling Green Flight Center LLC · Bowling Green, OHN334CBBarrett Jeff B · Mendota, ILN334CCHaspell John C · Broken Arrow, OKN334CHLittle River Aviation LLC · Tifton, GAN334CKLyders-Petersen Peter · Brighton, MIN334CPRws Aviation LLC · Indianapolis, INN334DBrady Michael H Trustee · Healdton, OKN334DMTailwind Aviators LLC · Carmel, INN334FLChampionx LLC · Sugar Land, TXN334GArcher Aero LLC · Wilmington, DEN334HCCannon Harold · Utica, KYN334HPN334hp LLC · Sheridan, WYN334JSchneider Mike · Inola, OKN334JDGolden Bear Properties LLC · Lakeside, AZN334JHGruener Jason C · Ridgeland, SCN334KWRoberts Dorel Lynn · Sheridan, WYN334LSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN334MBSutherland Scott G · Longmont, CON334MEKline Timothy J · Van Nuys, CAN334MTBlomquist Mark S · Gardiner, MTN334NDUnd Aerospace Foundation · Grand Forks, NDN334PBConway Brian · Denver, CON334PCMagic Valley Auction LLC · Jerome, IDN334PDCurtis Darrin M · Woodland, CAN334PWGary Bass Restorations LLC · Monett, MON334RN566rw LLC · Hensley, AR
Back to AD 2007-04-19 R1