Registered aircraft · 56,580

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-14-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:79-10-14-R1') 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-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N3167SLightning Bolt Aviation LLC · Bozeman, MTS/N 18255667 N3168CRegistration Pending · Anchorage, AKRegistration pendingS/N 30967 N3168DBovee John W Or · San Diego, CABuilt 1955 · S/N 31966 N3168RRunck Russell E · Watertown, MNBuilt 1967 · S/N 18258568 N3168VAirgo Inc · Cetralia, ILBuilt 1974 · S/N 15076407 N3168YSkydive Central New York LLC · Weedsport, NYBuilt 1962 · S/N 18254168 N3169TOwen James D · Fort Lauderdale, FLBuilt 1967 · S/N 17700469 N3169XVirgilio Domenico · Rochester Hills, MIBuilt 1966 · S/N 15064569 N316ACheng Williams W · North Potomac, MDBuilt 1979 · S/N 17273226 N316ASChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9810 N316CAChoice Aviation LLC · Hamilton, MTS/N 17265960 N316DCAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12899 N316EPMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11682 N316HCChilders Henry Dr · Lewes, DEBuilt 2024 · S/N 18283270 N316HYLakeview Aviation Inc · Newport, VTBuilt 1977 · S/N 17702651 N316JHNorthern Arizona Investment Group LLC · Prescott, AZBuilt 2004 · S/N 18281345 N316LSC M & N D Inc · Wilmington, DEBuilt 1964 · S/N 18255604 N316MLJump N316ml LLC · East Berlin, PABuilt 1969 · S/N P2060549 N316PCRegistration Pending · Payson, AZRegistration pendingBuilt 1968 · S/N 15069440 N316RWFour States Tire & Service Inc · Cortez, COBuilt 1979 · S/N 21063447 N316SFDoc Aviation LLC · Ponca City, OKBuilt 1964 · S/N 18255668 N3170JDobrzynski Andrzej J · Chicago, ILBuilt 1966 · S/N 15065870 N3170QRenfrow Denny · Kelseyville, CABuilt 1967 · S/N 18258170 N3170UHarrison Brian C · New London, OHBuilt 1962 · S/N 18254570 N3170XFlying L Aircraft Inc · Fort Denaud, FLBuilt 1966 · S/N 15064570 N3170YStillson John L · Rock Rapids, IAS/N 18254170 N3171CLand Sea & Air Inc · North Mankato, MNBuilt 1954 · S/N 30970 N3171DJohnson Donald B · Lino Lakes, MNBuilt 1955 · S/N 31969 N3171EJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271459 N3171FRockin Rt LLC · Smithfield, UTS/N 18257271 N3171JRay Charles B · Prosser, WAS/N 15065871 N3171TVanlandingham Michael E · Oxnard, CABuilt 1967 · S/N 17700471 N3171XJohnson Christopher A · San Diego, CABuilt 1966 · S/N 15064571 N3171YDj Aviation LLC · Newburgh, INBuilt 1962 · S/N 18254171 N3172BBeon Robert L · Belgrade, MES/N 25414 N3172EKruchten Larry A · Scottsdale, AZBuilt 1982 · S/N 18268237 N3172FKuhn Joseph C · Manhattan Beach, CABuilt 1973 · S/N A1500407 N3172SSterling Flyers LLC · Lehi, UTS/N 18255672 N3172YPeters Barry S · Montague, CABuilt 1962 · S/N 18254172 N3173BHaynes Stefen L · Homer, AKBuilt 1952 · S/N 25415 N3173CMcgaha Justin L · Hooker, OKS/N 30972 N3173ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271461 N3173FJames Pearl LLC · Norfolk, VABuilt 1966 · S/N 18257273 N3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeBuilt 1964 · S/N 18255673 N3173XRegistration Pending · Lutz, FLRegistration pendingBuilt 1966 · S/N 15064573 N3174DRegistered aircraftBuilt 1955 · S/N 31972 N3174FRozier Harold H Jr · Blackshear, GABuilt 1966 · S/N 18257274 N3174QMclaughlin Daniel R · Xenia, OHBuilt 1967 · S/N 18258174 N3174UMorris Debbie L · Columbus, GABuilt 1963 · S/N 18254574 N3174XRenner Colton A · Easley, SCBuilt 1966 · S/N 15064574

Back to AD 79-10-14 R1