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.
N2728PBrown James A · Fairbanks, AKN2728QDanmick Holdings LLC · Dickson, TNFirst renewal noticeN2728TMilk Ranch LLC · Stephenville, TXN2728WNash Richard D · Edgewood, WAN2728XUsda Forest Service Fepp · Trenton, NJN27293Williams Steven C · Anchorage, AKN2729FSexton & Sanders Law Firm Pa · Fort Smith, ARN2729LVip Wellness LLC · Victoria, TXN2729QCraft Phyllis C · Damascus, GAN2729TWasileski David J · Auburn, NYN2729XMoeplanes Co · Boynton Beach, FLN272AAEdj Aviation Limited · Fort Myers Beach, FLN272ACFlying Radish LLC · Vineyard Haven, MAN272AFEarly Roy W · Beaver, PAN272BBearair II LLC · Libertyville, ILN272BDDanby James D · High Rolls, NMN272BSHes Aircraft LLC · Auburn, ALN272CSkythrills! LLC · Fullerton, CAN272CBCalifornia Baptist University · Riverside, CAN272CCFarkas Jordan C · Anchorage, AKN272CPPetracca Carmine O D · Lewiston, IDN272CTInncal Inc · Stockton, CAN272DBBrock Dean R · Hawthorne, FLN272DGDeutscher Kevin W · Chandler, AZN272DKKroutil David W · Hilmar, CAN272DRMiller Seth A · Sahuarita, AZN272DWBb Wetlands LLC · Winter Haven, FLN272ECBurchett Michael · Bettendorf, IAN272FBlanchard Aviation LLC · Waynesboro, GAN272FDFly Dynasty Corp · Ocala, FLN272FGRidgeline Assets LLC · Wilmington, DEN272GBaudouin Dameries · Pagosa Springs, CON272GTNfh Aviation LLC · Pikeville, KYN272HFHorizon Flight Center LLC · Chesapeake, VAN272HWHot Wings Aviation LLC · Fishers, INN272JAGold Coast Aviation LLC · Oxnard, CAN272JWGlobal Aerials Inc · Pembroke Pines, FLN272KMHickman Michael G · Longmont, CON272KSOlson Richard · Eau Claire, WIN272LCPen And Pilot Inc · Flagler Beach, FLN272LPAa-Aero Inc · Fairfield, NJN272MGAircraft Evolution LLC · Miami, FLN272MLRegan Michael E · Bend, ORN272MMTownair LLC · Sandy, UTN272MSHinkle Paul · Broken Arrow, OKN272NSKroeber Thomas · Pawlet, VTN272QFlying Docs LLC · Tomball, TXN272RARomeo Alpha Flyers Inc · Nashville, TNN272RRGray Kerry · Monterey, CAN272SBofinger Jr John M · Hewitt, NJ
Back to AD 2007-04-19 R1