OpenAirDocs.org
AD 69-09-01

Registered aircraft · 17,809

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

N100Bene Mary D · Ketchum, OKBuilt 1940 · S/N 5334N1000MValdez Raymond G · Las Vegas, NMS/N 108-3741N1001EBellas Bryan Turner · Geneva, OHBuilt 1946 · S/N 7AC-4551N1002EMccurdy James R · Hampden, MEBuilt 1946 · S/N 7AC-4552N10036Roberts Bruce D · New London, PABuilt 1944 · S/N 11906N1003EMichael Carothers · Aldie, VABuilt 1946 · S/N 7AC-4553N1003KScott Michelle · Vallejo, CABuilt 1946 · S/N 3730N1004ZCovey Lawrence R · Port Saint Lucie, FLBuilt 1963 · S/N RGH-1N1005KKing Richard J II · Rose Creek, MNBuilt 1946 · S/N 3732N1006LAnderson Richard A · Sycamore, ILBuilt 2005 · S/N 1234N100CRFreudenberg Joseph B · Almira, WABuilt 1947 · S/N 5050N100DVHarvey Donald W · Concord, NCBuilt 2009 · S/N 1000N100ZYWalden Taylor G · Pueblo, COBuilt 2016 · S/N ONEN1010KCooley Joshua · Kenai, AKBuilt 1971 · S/N 2068CN1012Papon Bruce · Hardtner, KSBuilt 1947 · S/N 11BC-106N10130Blunt Alan W · Granger, INBuilt 1958 · S/N 7BCM-971N10133Fisher Charles R Jr · San Antonio, TXBuilt 1948 · S/N NAV-4-1766N1013KBall Jeffrey A · Harrison, ARBuilt 1946 · S/N 3740N10142Scherer Charles K · Delray Beach, FLBuilt 1959 · S/N 001N10145Hensarling Matthew L · Elizabeth, COBuilt 1948 · S/N 48-999N10149Price John · Bennington, KSS/N P-510N10152Lutz Michael A · Findlay, OHS/N 0001N1015KMichaud Paul · Forest Lake, MNBuilt 1946 · S/N 3742N10169Mccroskey Danny D · Ward, ARS/N 101N10188Maggio Rocco M · Waupaca, WIBuilt 1947 · S/N 7BCM-4N10195Deuchar Hillary · Brookings, ORS/N 562N1019ELeonard Jason · Port Saint Lucie, FLS/N 4570N101BNHigh Alpha Airshows LLC · Camarillo, CAS/N 305N101GRAlshamari Ahmad M · San Mateo, CABuilt 1946 · S/N 9749N101JARegistration Pending · Churubusco, INRegistration pendingBuilt 1972 · S/N 2N101RKettunen Alan C · Ashtabula, OHBuilt 1946 · S/N 2125N101RDLockerby Wade E · Isle La Motte, VTS/N D-101N1021LGault Allen D · Katy, TXBuilt 2014 · S/N RA401N1023EKimbrel Martin E · Oakville, WABuilt 1946 · S/N 7AC-4574N1025ERatzin Brendan · Pahrump, NVBuilt 1946 · S/N 7AC-4576N1026ELampros James C · Salem, ORBuilt 1946 · S/N 7AC-4577N1027EBuckley Joseph J · Mora, MNBuilt 1946 · S/N 7AC-4578N1028EWalters David W · Maricopa, AZS/N 7AC-4579N1029KCrabbe Michael B · Galloway, OHBuilt 1946 · S/N 3756N1029SMccoy Jeffrey F · Burleson, TXBuilt 2004 · S/N M-345N102BHVanderpool Gary W · Alamo, TXBuilt 1945 · S/N 11AC-474N102RJKnabe Michael D · Willianson, GABuilt 1957 · S/N 211N102ZXJurado Lance M · Ocklawaha, FLBuilt 2008 · S/N 1101N10314Sweitzers Fencing Co · Felton, PABuilt 1946 · S/N 7AC-5798N1031BN1031wd LLC · Dover, DES/N 7430A-508BN1032EDannecker Christopher T · Lake City, FLBuilt 1946 · S/N 7AC-4583N1033BRudd Wayne G · Basalt, COBuilt 1979 · S/N 1N1034KSpivey Harold E · Thomaston, GABuilt 1946 · S/N 3761N1035KDrake Thomas E · Phoenix, AZBuilt 1946 · S/N 3762N1036EWhite James F Jr · Abingdon, VABuilt 1946 · S/N 7AC-4588
Back to AD 69-09-01