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.
N4940ASims Charles A · Chugiak, AKN4940DAirborne One LLC · Kalispell, MTN4940EFlyright Aviation Inc · North Las Vegas, NVN4940FJackson Christopher M · Clearwater, FLN4940GN4940g LLC · Portsmouth, NHN4940KGoves Abram M · Parker, CON4940LDrown William K · Columbus, OHN4940NWray James R Jr · Brighton, CON4940PArpey Aviation Ltd · Colleyville, TXN4940SO'Gorman Robert W Jr · Wake Forest, NCN4940UBoard Of Regents Of The University Of Oklahoma · Norman, OKN4940WKitt Consulting LLC · Boardman, OHN4941AMartinello Domenic · Clarksville, TNN4941VClark Robert J · Brookshire, TXN4942AChapman Peter E · Placerville, CAN4942DN4942d LLC · Greenfield, NHN4942PSchulz Beverly A · Merrill, WIN4942UCenturion LLC · Bonney Lake, WAN49434943 LLC · Kalispell, MTN4943EPettit Robert · Carnegie, OKN4944CCoke Richard · Bedford, TXN4944DSelkirk Associates Inc · Wilmington, DEN4944LWilson Zane D · Fairbanks, AKN4944PReed John Richard · Charleston, ILN4944RRoma Air Corp · Belle Glade, FLN4944SEmbry Riddle Aeronautical University · Prescott, AZN4945AIverson Randy · Winnemucca, NVN4945CFandango Ranch Operating Co Inc · Bend, ORN4945FEmerald City Aircraft Leasing Inc · Port Orchard, WAN4945JAsher Academy · Cameron, TXN4945LAlahmadi Hussein I · Avon, CTN4945MMidland College · Midland, TXN4945WBlueline Flight Systems LLC · Orlando, FLN4946ESallmon Helga R · Sandpoint, IDFirst renewal noticeN4946KOrion Technology Group LLC · San Diego, CAN4946LAndrews University · Berrien Springs, MIN4946TElite Fleet Jacksonville LLC · Jacksonville, FLN4946VJennings Carl M · Au Gres, MIN4947AGleiter David W · Overland Park, KSN4947DEnstrom Thomas · New Berlin, NYN4947GRiya Aviation LLC · Tracy, CAN4947JElite Fleet LLC · Spofford, NHN4947LAmoth Dallas V · Bonners Ferry, IDN4947QDavison Aviation LLC · Garnett, KSN4947SZams Aviation LLC · Raleigh, NCN4947WBloom Kevin Lynn · Freeport, FLN4948Andersen Bret E · Chugiak, AKN4948AKeystone Aerial Surveys Inc · Philadelphia, PAN4948CRobillard Ross · Eveleth, MNN4948DSobrado Victor M · Norman, OK
Back to AD 2007-04-19 R1