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.
N475PCSaint Louis University · Saint Louis, MON475PSInosculation 2 LLC · Summerville, SCN475RBN475rb LLC · Lexington, KYN475TDSeitz David J · Mauston, WIN475TFV1 Capital Advisors LLC · Boca Raton, FLN475TTTubb Jeffrey Scott · Farmington, NMN475TVPaine Twin Comanche LLC · Redmond, WAN475WDWilloughby Dan J · Linden, MIN475WHWidoff Howard Trustee · Eugene, ORN47600Stukus David · Exeter, RIN47601Phoenix Flyers Inc · Mesa, AZN47603Kor Joshua · Montgomery, MNN4760AMcgarrh James R III · Byhalia, MSN4760EYoung John L · Glorieta, NMN4760HBrh Aviation Inc · Indianapolis, INN4760LSouthern Utah University · Cedar City, UTN47615Miloud Chadd K · Fort Worth, TXN47617Owen Keith L · Columbus, GAN4761AAmarel Robert E Jr · Yuba City, CAN4761CForbis Aviation LLC · Calera, OKN4761DNordstrom Anne D Trustee · Walpole, NHN4761EDorsheimer Ryan J · Camp Hill, PAN4761KLyman Leslie F · Walnut Grove, CAN4761QMichaelson Lawrence · Big Lake, AKN4761SSteed John H · Columbus, GAN4761TWorden Frederick F · Tucson, AZN47622Wing Nuts LLC · Manitowoc, WIN4762BAllen Kenneth W · Anchorage, AKN4762EFly185 LLC · Estes Park, CON4762LRegistered aircraftN4762RGraham Richard · Judsonia, ARN47630Adolph Gerald · New Rochelle, NYN47634Heckler Mark A · Godfrey, ILN47636Caribbean Flyers LLC · Elizabeth City, NCN4763AHunt Bryan G · Poplar Grove, ILN4763DRandolph Terrence · Bowie, MDN4763EZimmerman Steven W · Olathe, KSN4763FPittsburgh Pilot Training LLC · Bethel Park, PAN4763GGamma Transport Solutions Inc · Carrollton, TXFirst renewal noticeN4763LRobson Kevin J · Carrabelle, FLN4763NBathum Dale · Ketchum, IDN4763SMayday Flyers LLC · West Jordan, UTN4763UCopper River Airmotive LLC · Copper Center, AKN47645Arizona Type Ratings LLC · Sedona, AZN47646Span Development LLC · Madera, CAN4764BPratt Sean · Hampton, NHN4764DQuadrelec Engineering Corp · Tulsa, OKN4764MSpooner James Leonard · Carlisle, PAN4764NWhite Robert H · Eagar, AZN4764QShapiro David · Homer, AK
Back to AD 2007-04-19 R1