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.
N2957KSutton Aircraft Salvage LLC · Palmer, AKN2957LJohnson Cullen L · Abernathy, TXN2957MJacobson Larry · Commack, NYN2957NBak John A · Lake Forest, CAN2957PArwine James L · Waxahachie, TXN2957RBantle Aviation LLC · Midlothian, VAN29581Bas Part Sales LLC · Greeley, CON29584Eagle Sky Patrol Inc · Deadwood, SDN29585Ramold Corey M · Gretna, NEN2958CSale Reported · Anchorage, AKSale reportedN2958KPionair Inc · ChamN2958LStormo Jarrod M · Indianapolis, INN2958SSmith Jimmie A Trustee · Rose Hill, KSN2958XCooper Ronald C · Fowlerville, MIN2958ZBryce Brad W · Lewis Center, OHN29592Reyner Matthew J · Georgetown, TXN29593Else John J · Toledo, IAN29595Delta Fox Corp · Schaumburg, ILN29596Murray Charles W · Reno, NVN2959DWatson Frank H · Central Point, ORN2959LMcphillips Jess H · Port Arthur, TXN2959MHanneman Robert · Claremore, OKN2959QParis Air Inc · Vero Beach, FLN2959USmart5 LLC · Kissimmee, FLN2959XCiochetti David · Kimberly, ORN295ABFogerty Barry L · Shawnee, OKN295ACFanjoy James Michael · Nehalem, ORN295AKGlick Farms Inc · Minot, NDN295BCWieler Jacob · Petty, TXN295BWWigglesworth Brad · Winnemucca, NVN295DAJackson Construction LLC · Charleston, SCN295EC295ec LLC · Eau Claire, WIN295FAStationair Amphib LLC · Jefferson City, MON295GSStine Scott · Vincennes, INN295GTMedina-Solla Edwin O · Carolina, PRN295JJElliott Jimmy F · Hesston, KSN295LPWildridge Aviation LLC · Layton, UTN295MAStanton David M Jr · Kiawah Island, SCN295MEWings Air Charter LLC · Wisconsin Rapids, WIN295PCFleming Charles R · Merritt Island, FLN295PEPhoenix East Aviation LLC · Daytona Beach, FLN295PLAerospring Leasing LLC DBA · Wasilla, AKN295RJRegistered aircraftN295RSBeisert Nikolas · Penn Valley, CAN295RWMac IV Aeroworks LLC · Saint Petersburg, FLN295SBChagres Aero LLC · Albuquerque, NMN295SRCarpenter William R · West Springfield, VAN295TC295tc LLC · Cape Coral, FLN29604Farrington John R · Cedar Park, TXN2960AGallman Alexander C · Livingston, TX
Back to AD 2007-04-19 R1