OpenAirDocs.org
AD 72-14-08 R1

Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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.

N3489QPlane Progress LLC · Waterloo, IABuilt 1967 · S/N 320E-0089N3491QOuter Marker Inc · Sandy, UTS/N 320E-0091N3492QLadet William D · Las Vegas, NVS/N 320E-0092N3494QRodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 320E-0094N3495QBoswell Alan · Chrisney, INBuilt 1967 · S/N 320E-0095N34MMSchubee Air Inc · Watkins, COBuilt 1967 · S/N 401-0125N350CHFly Bye LLC · Georgetown, DEBuilt 1973 · S/N 310Q0910N350SDAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1970 · S/N 310Q0065N352LBurdick Rich · Montrose, COBuilt 1958 · S/N 35769N353DCulver Marc D · Anchorage, AKBuilt 1956 · S/N 35353N3540MDybel William P · Frankfort, ILS/N 421B0472N355RTBeechwood Aviation LLC · Wilmington, DEBuilt 1974 · S/N 421B0633N35FSSelistli LLC · San Mateo, CABuilt 1974 · S/N 421B0831N35VCGomez Victor · Isabela, PRBuilt 1969 · S/N 401A0126N3607DCusick Christopher J · La Jolla, CABuilt 1956 · S/N 35307N3616DRobinson Mark V · Vacaville, CABuilt 1956 · S/N 35316N3618GIndustrial Consulting LLC · Repton, ALBuilt 1956 · S/N 35313N3631DMortgage Experts LLC · Homestead, FLBuilt 1956 · S/N 35331N3636CSale Reported · Galena, KSSale reportedBuilt 1966 · S/N 310K0137N3639DOlah Michael J DBA · Mazomanie, WIBuilt 1956 · S/N 35339N3641DAdkins Steven · Oriental, NCBuilt 1956 · S/N 35341N3642DCorre Training Industries Inc · Federal Way, WABuilt 1956 · S/N 35342N3647DVmc Aviation · Upland, CAS/N 35347N3648DFerry Theodore D · Bellevue, WABuilt 1956 · S/N 35348N364APMartin John T · Paradise, CAS/N 35340N3667DBpm Rentals Inc · Lincoln, CABuilt 1956 · S/N 35367N366DHummer Family Capital Aviation LLC · Boonton, NJBuilt 1966 · S/N 310K0230N3674DUS Flight Academy International Inc DBA · Post, TXBuilt 1956 · S/N 35374N3679DCheney Joseph F · Daphne, ALS/N 35379N367ATL&R Aircrafts Corp · Boynton Beach, FLBuilt 1972 · S/N 310Q0522N3681DGcsw Holdings Inc · Poplar Grove, ILBuilt 1956 · S/N 35381N3682DLasseter Granville D II · Richmond, TXBuilt 1956 · S/N 35382N36CGDay Edwin Daniel · Richland, WABuilt 1969 · S/N 310P0075N36DLCroll Robert H III · Jacksonville, ORBuilt 1969 · S/N 310P0113N36EWSalzer Dustin J · Weatherford, TXS/N 310Q0521N372JCompass Rose Services Inc · Powell Butte, ORBuilt 1966 · S/N 320D0114N372NMShelter Michael R · Sandy Lake, PABuilt 1970 · S/N 310Q0115N373JCVon Allman Chris D · Dos Palos, CABuilt 1962 · S/N 310G0137N374TAVintage Aero Inc · Brandon, FLBuilt 1974 · S/N 310Q1105N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803N37JKSsr LLC · Incline Village, NVS/N 421B0934N37MBresciani Martin · Guaynabo, PRS/N 421B0805N3809XVoracek Michael G · Richardson, TXBuilt 1966 · S/N 310K-0209N3812XJets And Props Corp · Reno, NVS/N 310K0212N3813XRegistered aircraftAssigned, pending cancellationS/N 310K0213N3817XPeterson Randall J · Lake Havasu City, AZBuilt 1966 · S/N 310K0217N3818XAcme Racing LLC · Overland Park, KSBuilt 1966 · S/N 310K0218N3819XBoerne Flight Options LLC · Boerne, TXBuilt 1966 · S/N 310K0219N3820XDwyhalo David W · Moorpark, CABuilt 1966 · S/N 310K0220
Back to AD 72-14-08 R1