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.
N4VZDiscovery Aviation LLC · Kalispell, MTN4WJRice James E · Piperton, TNN4WLOstrich James T · Redding, CAN4WNBlair Aircraft No 2 LLC · Herriman, UTN4WQKittinger Aviation LLC · Calhoun, KYN4WRShoemaker David J · Menlo Park, CAN4WSZeller Robert A · Oro Valley, AZN4WWWarren Gregory C · Redmond, ORN4WZMulligan Peter · Richardson, TXN4XBThibault Thomas N · Granbury, TXN4XCMinnehan Land & Cattle Co · Joplin, MTN4XKElliott Robert E III · Vancouver, WAN4XNMiller Donald W · Harrisonburg, VAN4XPPazdziora Ronald G · St Charles, ILN4YASoaring Eagle Southwest LLC · Fort Mohave, AZN4YDSlobodan Savic · New York, NYN4YHMendonca Douglas R · Mariposa, CAN4YLRobinson Roger Jr · Saint Johns, FLN4YPBobs Biz Ltd · Minster, OHN4YTMclaren Paul E · Pensacola, FLN4YVDonnie Young Farms Inc · Ulysses, KSN4YWGermann David E · Chesterfield, MIN4YYWilliams Scott Griffin · Salt Lake City, UTN4YZLackerdas Harry · Melba, IDN4ZVBiever Michael J · Eatonville, WAN4ZWSpencer Scott A · Brownsburg, INN4ZYValiair Ltd Co Trustee · Casper, WYN50008Osowski Wes A · Kodiak, AKN5000CFly Right LLC · Burlington, WIN5000LTrobaugh Michael A · Highland, ILN5000QNowalzyk Daniel C · Downers Grove, ILN5000UMci Air LLC · Wilmington, DEN5000WWarren Joseph E · Dothan, ALN5000YSutter Street Holdings LLC · Santa Monica, CAN50011Taco George Aviation LLC · Coppell, TXN5001DTatter David W · Kingman, AZN5001FReynolds Darryl G · Wills Point, TXN5001RLe Conte LLC · Anchorage, AKN5001UOew Aviation LLC · Sumter, SCN5001WHayes Gregory S · Erie, PAN5001XVirginia Brian · Maple Grove, MNN5002POrtman Bernard · Deer Park, TXN5002SAsasnoceu LLC · Fort Myers, FLN5002TPenn Yan Flying Club Inc · Penn Yan, NYN5002YGlobal Aviation Florida LLC · Pompano Beach, FLN50036Vetterman Larry D · Hot Springs, SDN5003DLawrence Richard D · Le Roy, NYN5003PLouwagie Bradley J · Marshall, MNFirst renewal noticeN5003WDts Flying LLC · Lake Alfred, FLN50045Drive A Tank Inc · Kasota, MN
Back to AD 2007-04-19 R1