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.
N516GZGrzelecki Michael J · Westfield, INN516JPFranjojo Airways LLC · Farmingdale, NYN516JTMarcum Brad G · Universal City, TXN516JWAerostar LLC · Newport Beach, CAN516LMGregory Michael P · Clayton, DEN516MAMidwest Wings LLC · Onalaska, WIN516MJSeaton Flying Services Inc · Kileen, TXN516MSSouth Bay Aviation Inc · Torrance, CAN516NANapoli Nikolaos · Jensen Beach, FLN516NDSunrise Aviation Inc · Ormond Beach, FLN516PCSpace Coast Aircraft Co · Merritt Island, FLN516PUAirplanes And Helicopters Of Oregon LLC · Sisters, ORN516RCCutter Robert W · Irmo, SCN516RJRomeo Juliet LLC · Anaconda, MTN516RVFoster Todd H · Long Beach, CAN516SABaron Aircraft Corporation · Richmond, VAN516SBKnapp Nicholas R Trustee · Portland, ORN516SCThomason Scott D · Greer, SCN516SPOrlando Aeroclub Inc · Orlando, FLN516TCVan Bortel Aircraft Inc · Arlington, TXN516TGNatchez Flight Training LLC · Natchez, MSN516WClearwater Holding LLC · Parkersburg, WVN51700Brown County Flying Club · Aberdeen, SDN5170DSandford Graves M · Moberly, MON5170GVihlen Steven C · Locust Grove, GAN5170MWheeler David A · York, PAN5170NVx LLC · Melbourne, FLN5170PBosch Christopher J · Bloomington, MNN5171Van Buskirk Steven · Denver, CON5171DFaber Elgin · Havre, MTN5171EL & D Air · Foley, ALN5171HPan Air Flying Club · Miami, FLN5171KBrewer Curtis E · Millington, TNN5171LCrum Clarence F · West Salem, OHN5171RSamuels Jay M · East Tawas, MIN5171SHalsted Holdings LLC · Yankton, SDN5171USummers Jeffrey L · Pekin, INN5171VLisenbey Edward · Caldwell, IDN5171WPeters W Benny · Garden City, KSN5172Beitler William J · Washington, PAN51723Rhoads Timothy C · Logan, NMN5172HMsi Fuel Management Inc · Vacaville, CAN5172RWaterhouse Roy Todd · Mccall, IDN5172WOcala Aviation Services Inc · Ocala, FLN51732Imsar LLC · Springville, UTN51735Styer David B · Milton Freewater, ORN5173ERyznar Daniel J · Anchorage, AKN5173LDevries Pat DBA · Germansville, PAN5173PColorado Aviation Group LLC · Colorado Springs, CON5173SDamore Joseph · Ingleside, IL
Back to AD 2007-04-19 R1