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.
N356DPMid America Aircraft LLC · O Fallon, ILN356DSRsmaviation LLC · Templeton, CAN356DWWeiss Bernard J Trustee · Saint Paul, MNN356GTPadre Bendice Este Vuelo LLC · Groveton, TXN356JBBokash Greg · Bridgeton, NJN356JTHorizon Aviation LLC · Mobile, ALN356MU S Department Of The Interior · Boise, IDN356MKNorth Star Aviation Inc · Mankato, MNN356MTGlasscock David L · Lakewood, CON356NDAir Shares LLC · Casper, WYN356PCGreen Seth M · Kissimmee, FLN356PVDalton Steven J · Plano, TXN356TAFlyktoc LLC · Lavonia, GAN356TBSky West Aviation Inc Trustee · Albuquerque, NMN356VAVictory Aviation Club Inc · Hamilton, OHN356WBMwm Interests Inc · The Woodlands, TXN35700Sutton Aircraft Salvage LLC · Palmer, AKN35701Mcha Aviation LLC · Vinita, OKN35705Paris Air Inc · Vero Beach, FLN35707Pray Aviation Inc · Augusta, KSN3570EBlackbird Aviation Corp · Van Nuys, CAN3570UDoyle Neil R · North Pole, AKN35711Pumphrey Robert B Jr · Saint Paris, OHN35712Mw Flying LLC · Sanford, NCN3571335713 LLC · Kitty Hawk, NCN35714Skyhawk Rising LLC · Manchester, IAFirst renewal noticeN35715Kindblade Aeronautics LLC · Casper, WYN35716Ward Seth W · Demorest, GAN35718Parmerlee David · Grand Rapids, MIN35719Jensen Greg D · Omaha, NEN3571GMid Continent Aircraft Corp · Hayti, MON3571LPeltier Scott M · Longwood, FLN3571NCoker Steve L · Tyler, TXN3571PRegistration Pending · Myrtle Beach, SCRegistration pendingN3571WJtw Financail Services · Norfolk, NEN3571YIllinois Valley Parachute Club · Carlock, ILN3571ZThompson Lyndon R · West Fargo, NDN35725Kling Jonathan N · Ruther Glen, VAN35726Jh Aero LLC · Little Rock, ARN35728Gone Broke LLC · Fairhope, ALN3572ADavis Robert D · Independence, ORN3572BPiper Aircraft Inc · Vero Beach, FLN3572GHauser Linda · Ulysses, KSN3572MPlane Nonsense Inc · Middletown, DEN3572PMulkey Joshua D · Anchorage, AKN3572QFloyd Richard C · Sutter Creek, CAN3572UFrappollo Paul M · Berryville, VAN3572XKelsoe Gregory Lyle · Clermont, FLN35730Miner Jay G · Seattle, WAN35731Registration Pending · Carthage, NCRegistration pending
Back to AD 2007-04-19 R1