Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N55731Leary Dennis E · Chesapeake Beach, MDBuilt 1973 · S/N 28-7325469 N55736Fox Ralph W II · Wilmington, NCBuilt 1973 · S/N 28-7305373 N55738Wenner William E · Kechi, KSBuilt 1973 · S/N 28-7325473 N55739Kepfer Robert · Felton, DEBuilt 1973 · S/N 28-7305456 N5573QAthens Neurology Professional Association · Athens, TXBuilt 1965 · S/N 2975 N5573WHokanson Elijah R · Ashby, MNS/N 28-668 N55742Doyal William T · Visalia, CABuilt 1973 · S/N 28-7325474 N55743B&R Aircraft LLC · Wadsworth, OHBuilt 1973 · S/N 28-7325475 N55744Williams Mike · Hartsville, INS/N 28-7325476 N55746Mccoy Michael E · Sanford, NCBuilt 1973 · S/N 28-7305459 N5574MSimpson David B · Oakhurst, CABuilt 1967 · S/N 108 N5574PPluck Mervyn M · Glendora, CABuilt 1958 · S/N 24-638 N5574UCooper Nicholas A · Plano, TXBuilt 1969 · S/N 28-26303 N5574WNordell Ryan J · Roberts, WIBuilt 1962 · S/N 28-669 N5575FBrewington Jesse L · Glenallen, MOBuilt 1968 · S/N 28-25011 N55761Ramirez Ramon E · Boynton Beach, FLBuilt 1973 · S/N 28-7305462 N55769Urban Joseph P · Ben Wheeler, TXBuilt 1973 · S/N 28-7325482 N5576LMartin Richard W · Raymore, MOBuilt 1981 · S/N 549 N5576UChambers Luther · New Philadelphia, OHS/N 28-26305 N5576WKoch Christopher P · Batavia, NYBuilt 1962 · S/N 28-678 N55771Christman Timothy J · Stillwater, MNBuilt 1973 · S/N 28-7305464 N5577FFederici Susan L · Vineland, NJBuilt 1968 · S/N 28-24910 N55780Sibayan Jose E · Lutz, FLS/N 28-7325483 N55783Djh Leasing LLC · De Pere, WIBuilt 1973 · S/N 28-7305467 N55785La Grange Aviation LLC · Bolingbrook, ILBuilt 1973 · S/N 28-7305469 N5578UHolmes Robert G · Jacksonville, FLBuilt 1969 · S/N 28-26308 N5578WVigano Davide · Redmond, WABuilt 1962 · S/N 28-685 N55790Buzzard Aviation LLC · Pace, FLBuilt 1973 · S/N 28-7325487 N55792Ramocinski Carson · Prescott, AZBuilt 1973 · S/N 28-7305471 N5579FSeaplane Adventures LLC · Cheyenne, WYBuilt 1968 · S/N 28-24912 N5579PBucciarelli Dominick F · Pueblo, COBuilt 1958 · S/N 24-643 N5579UInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-26887 N557DJMclain Aviation LLC · Lyons, GABuilt 1973 · S/N 17262420 N557DTRedace LLC · New York, NYBuilt 1985 · S/N 28-8690022 N557JBWages Zachary A · Pottstown, PABuilt 1999 · S/N 21318 N557PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842094 N557RRCuller David A Jr · Virginia Beach, VABuilt 1997 · S/N 3511 N557SWMarshall John F III · Sterling Heights, MIBuilt 1968 · S/N 28-25193 N55801Jacobs Michael A · Modesto, CABuilt 1973 · S/N 28-7325488 N55802Thomas Tommy A · Garden Grove, CABuilt 1973 · S/N 28-7305473 N55803Georgoulianos Anthanasios · Sweetwater, NJBuilt 1973 · S/N 28-7305475 N55808Oltrogge Michael · Bancroft, NEBuilt 1973 · S/N 287305416 N5580WSmitty 172 LLC · Rockford, MIS/N 28-691 N55811Scott Tyler C · Ball Ground, GABuilt 1973 · S/N 28-7325490 N55816Flying Manatees LLC · Wilmington, DEBuilt 1973 · S/N 28-7325492 N55818Lovejoy Aviation LLC · Cato, NYBuilt 1973 · S/N 28-7325494 N5581WRay Justin P · Centre, ALBuilt 1962 · S/N 28-666 N55823Steele Lawrence D · Belleair Beach, FLBuilt 1973 · S/N 28-7305436 N55824Ray Foster Stephen · Stockton, CABuilt 1973 · S/N 28-7325495 N55827Debonis Nicholas Michael · Woodland, CABuilt 1973 · S/N 287305477

Back to AD 79-10-03 R2