OpenAirDocs.org
AD 81-18-07

Registered aircraft · 199

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

N103GClifford Michael P · Paris, TXBuilt 1950 · S/N A533N1140Beechboys Aviation LLC · Wilmington, DEBuilt 1946 · S/N A-129N11863Schwendenman Zachary M · West Covina, CAS/N 51-11863AN118DJInternational Air Services Inc Trustee · Carson City, NVBuilt 1943 · S/N 43-35634N121SCNorth Bay Air Museum · Sonoma, CABuilt 1946 · S/N A-85N125MBLewallen William J · Arizona City, AZBuilt 1942 · S/N AF-286N127MLNiemyjski Justin · Franksville, WIBuilt 1946 · S/N A-212N145AZAmerican Airpower Heritage Flying Museum Inc · Dallas, TXS/N A-235N145JMelton Ricky N · Luttrell, TNBuilt 1943 · S/N 51233N1480KTheberge Jane A · Oakland Park, FLBuilt 1961 · S/N BA-601N14PWAudemus Inc · Newport News, VAS/N AF-314N150PRAerojet Servivces Inc · Aurora, COS/N AF-382N1597Registration Pending · Laguna Beach, CARegistration pendingBuilt 1953 · S/N AF-527N165ZAHoffman Carl A · Newnan, GABuilt 1953 · S/N AF543N167ZAAgather V Neils · Fort Worth, TXBuilt 1954 · S/N AF-692N1801DKlaers Lawrence B · Waconia, MNBuilt 1952 · S/N A-816N1828DWalker Matthew James · Henderson, NVBuilt 1952 · S/N A-837N184KPPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N CA-130N1850North Shore Aviation Services Corp · Waialua, HIS/N AF744N189RHoughton Justin · North Ferrisburg, VTBuilt 1962 · S/N 51-11766N18DTriple Four Mike LLC · Ponte Vedra Beach, FLS/N AF-29N18G416wy LLC · Sheridan, WYBuilt 1959 · S/N BA-469N18RWBeechballz LLC · Port Orange, FLBuilt 1963 · S/N BA-653N1939KCrazy Woman LLC · Tupelo, MSS/N BA403N197LAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N A-361N200KUMilitary Aircraft Restoration Corp · Costa Mesa, CABuilt 1946 · S/N 67103N213DEVintage Wings Aircraft LLC · Centerpoint, INBuilt 1942 · S/N AF-392N213SPBeech O Sphere LLC · Casper, WYS/N AF-860N21534Cartwright John P · Watkinsville, GABuilt 1945 · S/N CA-134N21CAJorgensen Bryan H · Wadsworth, OHBuilt 1946 · S/N A-250N21FSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N CA-138N21PNDms Leasing Co LLC · Las Vegas, NVS/N CA-181N223CMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N CA223N2292KB & K Leasing Inc · Nantucket, MABuilt 1951 · S/N CA-8N22BRDakota Express LLC · Wilmington, DEBuilt 1965 · S/N BA-729N231LJBlackhawk Aircraft Maintenance Inc · Janesville, WIBuilt 1945 · S/N 23835N2382BReed Hollow Aviation LLC · Franktown, COBuilt 1950 · S/N CA261N23BRDakota Express LLC · Wilmington, DES/N BA-159N241DBarron Aviation LLC · Perry, MOBuilt 1961 · S/N AF-850N245MDawson Jamie Stewart · Celina, TXBuilt 1963 · S/N BA-646N26035Aom Aircraft LLC · Wilmington, DES/N BA-754N2625Aero Specialists Inc · Eloy, AZBuilt 1952 · S/N AF-601N26PLTwin Beech LLC · Kalispell, MTBuilt 1964 · S/N BA-679N2833GVintage Aero Inc · Brandon, FLBuilt 1951 · S/N AF-159N2913BW Air Collection Inc Trustee · Wilmington, DEBuilt 1953 · S/N A-963N29BAMax Q Aviation LLC · Kalispell, MTS/N BA-625N2APNipper Samuel M · Hampton, GABuilt 1954 · S/N 48-9493N30GAg Air Inc · Matthews, MOBuilt 1946 · S/N A-131N30GBMission Air Aviation LLC · Roanoke, VABuilt 1964 · S/N BA-688N310GBMission Air Aviation LLC · Roanoke, VABuilt 1954 · S/N AF-856
Back to AD 81-18-07