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.
N3363YCamlik Air LLC · Wausau, WIN33640Red Rooster Rentals LLC · Alto, GAN33641Sutton Aircraft Salvage LLC · Palmer, AKN33642Smith Gary E · Des Moines, IAN33648Sadiq Ahmed · Ontario, CAN3364AVan Heel Tyler R · Newberg, ORN3364BDilley Darrel L · La Salle, CON3364DKtr Aviation LLC · Evans, CON3364EPlsr LLC · Denton, TXN3364FCrouch Jeffrey Lane Jr · Grimesland, NCN3364SAir Deeken Ltd · Doylestown, OHN3364THigh Mesa Aviation LLC · Naturita, CON3364UPalladino Frank · Castleton, NYN3364WOconnell Killian R · Amherst, MAN3364XDel Bene Dean A Trustee · Monee, ILN3364YSpeth Peter P · Peru, INN33655Gordon William S III · Aurora, CON33659North Central Flight Center LLC · Warwick, RIN3365BSmith James A · Lyle, WAN3365FTimlor Inc · Warrenton, ORN3365SWinger Cattle Co Inc · Johnson, KSN3366Sutton Aircraft Salvage LLC · Palmer, AKN33661Baker Justin Robert · Red Oak, TXN33663Brown Tony Mac II · Bowling Green, KYN33666Hancock Carl M · Glendale, AZN33667Aptum Aviation Inc · Hicksville, NYN33668Northeast Cubs LLC · Wilmington, DEN3366PLccc Enterprises Inc · Jupiter, FLN3366ST R Webster And Son Inc · Rexburg, IDN3366UAbraham Alan · Pilot Point, TXN3366YCrawford Stephen E · Corinth, TXN3367Klaasmeyer Construction Co · Conway, ARN33672Nulton Enterprises LLC · Johnstown, PAN33673Borregard Robert Stephen · San Jose, CAN33674Beaulieu Marc R · Lewiston, MEN33676Bous Harry John · Cayce, SCN33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeN3367PJackson Lee Roy Jr · Needville, TXN3367RRegistered aircraftN3367SSierra Co Llp · Wendell, IDN3367UKellogg David J · Marshall, MIN33684Coletti John · Grant Park, ILN3368FA&W Air LLC · Aiken, SCN3368RRegistered aircraftAssigned, pending cancellationN3368SForbes Amanda M · Huachuca City, AZN3368TTuley Richard L · Marietta, GARegistration revokedN3368UZeigler Ryan C · The Dalles, ORN3368WRegistration Pending · Bulverde, TXRegistration pendingN3368XI Have A Plane LLC · Lake Oswego, ORN3368ZWatts Paul D · Weatherford, TX
Back to AD 2007-04-19 R1