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.
N5495HPeirce Kellie N · Mc Grath, AKN5495JMesquite Express LLC · Waco, TXN5495KI Fly High LLC · Mesa, AZN5495PMilligan David Bourke · Locust Grove, GAN5495THill Mark D · Magnolia, TXN5495VPhillips Ruffin P Jr · Lexington, NCN5495WWings Over Lake Norman LLC · Mooresville, NCN54960First Eclipse Ltd · Richmond, VAN54968Kangas Kevin L · Fairbanks, AKN5496DYuhr Keith D · Miami, FLN5496EFair John C · Rockport, TXN5496HWilson Charles L · Seattle, WAN5496LRoda Richard H · Wakefield, RIN5496PStreetman Bryan Scott · Palm Coast, FLN5496WMaddux Dawayne E · Weeki Wachee, FLN54972Snider Scott E · Turner, MTN5497BBlue Sky Powers N5497b LLC · Dover, DEN5497LCardelli Steve V · San Bruno, CAN5497NBeelieve LLC · Carmel, INN5497SVerbovskiy Vitaliy Viktorovich · Clovis, NMN5497WJethro Charter Flights LLC · Jacksonville, NCN54983Jin Jin Aviation LLC · Anchorage, AKN5498HGulf Atlantic Airways Inc · Gainesville, FLN5498PC & J Ventures LLC · Center, CON5498WBas Part Sales LLC · Greeley, CON54990Hoffman Maurice M · Bowdle, SDN5499PLabelle Consulting Group Inc · OntarioN5499UDavis Bret K · Boynton Beach, FLN5499WVerchick Peter A · Jacksonville, FLN549ASouthern Illinois University · Murphysboro, ILN549ACWhitaker James C · Washington, NCN549BWhite Judy C · Fall City, WAN549BCMitchell Rosemary · Harbour IslandNon-citizen corporation, flight hours not reportedN549BKBarenfeld Marc F · Angels Camp, CAN549CDValiair Limited Co Trustee · Casper, WYN549EREmbry-Riddle Aeronautical University Inc · Prescott, AZN549JTPas Aviation Inc · Modesto, CAN549LMRundall Tanner R · Cedar Park, TXN549MAHinkle Airspray Inc · Cavalier, NDN549NDSpartan Education LLC · Tulsa, OKN549PTGrant P T · Musella, GAN549RVDelzell David Wayne · Heath, TXN549SCSpartan Education LLC · Tulsa, OKN549TSayers James B · Edison, OHN549TSAggregate Material Services LLC · Van Nuys, CAN549WSBoraam Aviation Inc · Prospect Heights, ILN549ZWMartin Riley J · Talkeetna, AKN54AFSpohnholz Randy K · Anchorage, AKN54AGLmv LLC · Kennebec, SDN54AJDietz Daniel James · Springville, IA
Back to AD 2007-04-19 R1