AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N1741NAero Optics Inc · Aguila, AZN1741VCollins E Randolph · Clemson, SCFirst renewal noticeN1742FMarsteller Bruce Paul Jr · Greensburg, PAN1743DCranton Larry J · Mesa, AZN1743FLittle Bird Airways LLC · Hamburg, NYN1744DJones William H Trustee · Wenden, AZN1744EDietz Steven C · Poplar Grove, ILN1745DStuczynski Jason S · Justin, TXN1745FClary David D · Elk Grove Village, ILN1745VReinholtz Edward J · Glasford, ILN1746NSmith Courtney E · Phoenix, AZN1747FSmith Jason F · Ronkonkoma, NYN1747QAleyda Aviation LLC · Berlin, NJN1748DWilliams Bobby G · Simi Valley, CAN1748FManning Malcolm · Senatobia, MSN1748NTengesdal Kenneth L · Maxbass, NDN1749QScott Andrew F · Beaufort, SCN174HMMid Atlantic Air Museum · Reading, PAN174TSteria Kermit J · Monahans, TXN1750FLeggett Lee D · Murfreesboro, NCN1751NTynes Edward R · Round Rock, TXN1751VScott William G · Lebanon, ORN1753DKlein John T · Austin, ARN1753KWinegarden Steven P · Sunnyvale, CAN1754NMorrison Rodney R · Hot Springs, ARN17559Barnhill Eric J · Seneca, SCN1755DMh Air Ventures LLC · Spokane, WAN1755FSummit Aviation LLC · Belton, SCN1755VMcclean James · Springfield, MON1756DBoote Ronald H · Los Olivos, CAN1756FHeistad Aviation Inc · Houston, TXN1756QVerhalen John P Jr · Scottsville, TXN1757DGossett Harold D Jr · Granbury, TXN1757FAcker David Lynn · Eugene, ORN1757VMollohan Timothy J · Otis, CON1758NMclaughlin James L · Centerburg, OHN1759DInternational Air Services Inc Trustee · Carson City, NVN1759FOklahoma Flight Academy LLC · Owasso, OKN175ASpencer Rimmel L · Haskell, OKN175AHAvonics LLC · Afton, WYN175BOffner William A · Amery, WIN175BAPlane Fun Inc Tr Trustee · Snellville, GAN175CBPr Aeronautics LLC · Buffalo, SDN175DHSegerstrom Ricky G Trustee · Grandview, TXN175EJudy Richard L · Beverly, WVN175ECBarlow James D · Hartwell, GAN175FMark Kossler · Bozeman, MTN175JTViolette Randy · Manchester, MEN175JVDelta Charlie Aviation Services LLC · Culpeper, VAN175MHall Nathan M · Palmer, AK
Back to AD 94-05-05 R1