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.
N28637Rust Scott Allen · Indianapolis, INN28639International Air Services Inc Trustee · Carson City, NVN2863ASkipper Jonathan H · Fayetteville, GAN2863EWetherley Aviation LLC · Boise, IDN2863FWright William J · Raeford, NCN2863MBaillie Ryan B · Hermitage, TNN2863PGic Inc · Oneill, NEN2863QSalsbery Randall E · Sharpsville, INN2863UEady Paul Clifford · Lakeside, CAN2863VBfree2fly LLC · Delaware, OHN2863WWarrick Motors LLC · Newton, IAN2863YPiontek Claudia A · Henderson, NVN2863ZWhitaker Eric L · Detroit, TXN28641Cpr Pacific LLC · Salinas, CAN28646Kutok Stephen M · Commack, NYN2864FPreszler Sharon J · Mesa, AZN2864QEaglet Flight Operations Lp · Fort Worth, TXN2864WSpearhead Ranch LLC · Douglas, WYN2864XCardinal Airways LLC · St Johns, FLN2864YAnderson Bruce A · Seville, OHN2864ZUecker Todd M · Port Townsend, WAN28650Loseka Tiger LLC · Columbia, ILN28651Dass Aaron · Conroe, TXN28655Straight & Level Aviation LLC · Bradenton, FLN28657Gutelius Kenneth · Lake Orion, MIN28658Hadden Aviation LLC · Sylacauga, ALN28659Timidaiski Daniel · Mikilteo, WAN2865FMctaggart Briar · Oroville, CAN2865QLasalle Charles H · Williamstown, NYN2865RCarmel Aviation Inc · Boise, IDN2865YSinclair Maurice A · Melrose, IAFirst renewal noticeN2865ZCrouder Trevor J · Fairbanks, AKN28663Ramsey Kelly · Argyle, TXN28664Aces Flying Services LLC · Sanford, NCN28667Rehberg Eric · Chattanooga, TNN2866ATruman Sparks Aviation LLC · Snyder, TXN2866BBulger Edward P · Newburyport, MAN2866FHowell Thomas F · Red Bluff, CAN2866KDobransky Robert J · Peoria, AZN2866QAircraft & Aviation Professionals LLC · Coldwater, MIN2866RCw Arborists Ltd · Sagaponack, NYN2866TPacific Coast Air Museum · Santa Rosa, CAN2866WBowman Field Flying Club Inc · Louisville, KYN2866XFeller Gerald A · Long Beach, CAN28672Woyshnis Kyle · Port Orchard, WAN28678Rubino Daniel A · Marion, KYN2867AShinkle Robert P · Sugar Creek Twnshp, OHN2867TN504fl LLC · Killeen, TXN2867URegistered aircraftN2867XThrush Air Lc · Mason City, IA
Back to AD 2007-04-19 R1