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.
N41477Shepro Scott M · Senoia, GAN4147BBaughman David W · Tijeras, NMFirst renewal noticeN4147EEnglerth Mark J · Wasilla, AKN4147GStinson Aaron M · Anchorage, AKFirst renewal noticeN4147KUniversity Of Illinois · Savoy, ILN4147NGeorge Robert J · Natick, MAN4147SDrew Danny Paul · Broken Arrow, OKN4147TChandler Air Service Inc · Chandler, AZN4147YReisdorf Steven R · Saint Cloud, MNN4147ZHopper Bruce · Chugiak, AKN41480Tradewind Aviation Co Inc · Blue Bell, PAN41482Cannella Ingrid D · Pineville, LAN41484Ferraro Jeffrey T · Mckinney, TXN4148CMjolhus Knut G · Amarillo, TXN4148DSkywest Leasing Inc · St George, UTN4148EDoody Michael C · Knoxville, TNN4148GKutrieb Wolfgang Michael · Chetek, WIN4148HRegistered aircraftN4148QRomeo Carmen J · Beaver, PAN4148TChristiansen Aviation LLC · Wilmington, DEN4148UFlightline Helicopters Inc · Cave Creek, AZFirst renewal noticeN4148WMirarchi Joseph F · New Braunfels, TXN4148YTailwheel Flying LLC · Rochester, MNN4148ZWillet Gerald E · Townsend, MTN41497Bagley Russell L · Frankston, TXN41498G&M Aircraft Inc · Wheat Ridge, CON4149ABoard Of Trustees · Savoy, ILN4149CBoard Of Trustees · Savoy, ILN4149DLangley Richard · Sheyenne, NDN4149GBoard Of Trustees · Savoy, ILN4149JElko Aviation Group LLC · Elko, NVN4149QMustain Michael J · Monticello, GAN4149SDelgado Dimitri Antonio · Tampa, FLN4149TCrosswinds Flying Club Inc · Bloomington, ILN4149XCyclic LLC · Kalispell, MTN414ACBirman Pablo · Suamico, WIN414AFSano Aviation Corp · Lewes, DEN414AKValiair Lc Trustee · Casper, WYN414AMToucan Aviation LLC · Lafayette, LAN414AQQualitair LLC Trustee · MichelstadtN414ARFlight Med LLC · Cumming, GAN414ASRobertson Julianne · Los Osos, CAN414ATCreekmore Arnold · Somerset, KYN414AWAlycone Trust Corp Trustee · Wichita, KSN414BAOptimal Health Systems LLC · Pima, AZN414BCRoche Robert C · Casa Grande, AZN414BDBostater Charles Jr · Indn Hbr Bch, FLN414BGGreen Forest Aviation LLC · Edmond, OKN414BH414bh LLC · Laramie, WYN414BLBig South Fork Aero Inc · Huntsville, TN
Back to AD 2007-04-19 R1