Skip to content

Registered aircraft · 54,015

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

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') ORDER BY n_number

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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N7342ANewberry Ernest B Jr · Crawfordville, FLBuilt 1957 · S/N 29442 N7342KPurvis Danny J · Anchorage, AKBuilt 1976 · S/N R1722060 N7342QThistlesoar LLC · Plaquemine, LABuilt 1972 · S/N 18260982 N7342TKeyes George E Jr · Moab, UTBuilt 1959 · S/N 46942 N73433Salvation Neighborhood Development Corp · Riverside, CAS/N 17267457 N73434Monette Verne G · Anchorage, AKBuilt 1976 · S/N 17267458 N73435Air America Spares LLC · Daytona Beach, FLBuilt 1976 · S/N 17267459 N73439Umo Flight School LLC · Mount Olive, NCBuilt 1976 · S/N 17267462 N7343ACheek Kenneth W · Yadkinville, NCBuilt 1977 · S/N A1500722 N7343ELemanski Joseph S · Grosse Ile, MIBuilt 1959 · S/N 57043 N7343MSheets Laura J · Follett, TXBuilt 1958 · S/N 55643 N7343XEnyart Patrick · Lindlakes, MNBuilt 1961 · S/N 15059443 N73441Stein Aporn U · Pepeekeo, HIBuilt 1976 · S/N 17267464 N7344MKiever Robert P Jr · Summerfield, FLBuilt 1958 · S/N 55644 N7344XOff LLC · Lonoke, ARS/N 15059444 N7344YJeffrey P Mcauley Dmd Inc · Midland City, ALBuilt 1977 · S/N R18200120 N73450Penn Yan Flying Club Inc · Penn Yan, NYBuilt 1976 · S/N 17267468 N73451Airward Inc · Columbia, CABuilt 1976 · S/N 17267469 N73452Hodges Jonathan D · Port Orchard, WABuilt 1976 · S/N 17267470 N73453Mfa LLC · Mount Pleasant, SCBuilt 1976 · S/N 17267471 N73454Yr-Aircraft Leasing LLC · Soldotna, AKBuilt 1976 · S/N 17267472 N73455101 Flight LLC · Waterford, MIBuilt 1976 · S/N 17267473 N73456K E F Enterprises · Plymouth, MABuilt 1976 · S/N 17267474 N73457Bmg Aviation Inc · Bloomington, INBuilt 1976 · S/N 17267475 N73459Stowers Joshua S · Niceville, FLBuilt 1976 · S/N 17267477 N7345GJacks Air Service Inc · Greenville, MEBuilt 1970 · S/N 17259045 N7345QLester Darrell S · Riverton, UTBuilt 1972 · S/N 18260985 N7345XStraytail150 LLC · Minneapolis, MNBuilt 1961 · S/N 15059445 N73461Monk Crafton L · Saraland, ALBuilt 1976 · S/N 17267478 N73462Farkas Dan · Wyoming, MIBuilt 1976 · S/N 17267479 N73464Knight Kevin J · Fort Wayne, INBuilt 1976 · S/N 17267481 N73467Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700594 N73468Tnt Airworks LLC · Hibbing, MNBuilt 1976 · S/N 17267484 N7346GBentley Darrell Howard · Powell, TNBuilt 1970 · S/N 17259046 N7346PIntegrated Avionics Services Inc · Hampstead, MDBuilt 1978 · S/N P21000007 N7346SWood Donald · Spring Branch, TXBuilt 1976 · S/N 18265137 N7346THalford Richard W · Eagle River, AKBuilt 1959 · S/N 46946 N73472Lajova LLC · Amarillo, TXBuilt 1976 · S/N 17267488 N73473Lauro Michael J · Kailua Kona, HIBuilt 1976 · S/N 17267489 N73477Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267493 N7347ATalkeetna Build A Plane Inc · Talkeetna, AKS/N 29447 N7347GN7347g LLC · Miami, FLBuilt 1970 · S/N 17259047 N7347NAv8 LLC · Boise, IDS/N U20603624 N7347QMitchell David L · Imperial, TXBuilt 1972 · S/N 18260987 N7347SRegistered aircraftAssigned, pending cancellationS/N 18265138 N73481N73481 LLC · Eaton, COBuilt 1976 · S/N 17267497 N73486Begley Edward · Glasgow, KYBuilt 1976 · S/N 17267501 N73487Spiess Michael Trustee · Montague, CABuilt 1976 · S/N 17267502 N73489Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1976 · S/N 17267503 N7348BPatry Andrew · El Mirage, AZBuilt 1977 · S/N A1520753

Back to AD 87-20-03 R2