Skip to content

Registered aircraft · 18,497

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

N4522KGoodman Jack A · Memphis, TNBuilt 1979 · S/N P21000209 N4523SLucky92 & Associates LLC · Reno, NVBuilt 1976 · S/N TE-1062 N4524SKnox James P · Park Rapids, MNBuilt 1975 · S/N E-727 N4527MF33 Air LLC · Selinsgrove, PABuilt 1978 · S/N CE-768 N4528JRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1980 · S/N T18803744T N4528SMoore William W · Merritt Island, FLBuilt 1975 · S/N D-9799 N4529MMetzler Aaron · Otis, COBuilt 1978 · S/N D-10115 N4529SRegistration Pending · Frisco, TXRegistration pendingBuilt 1975 · S/N CE-600 N452CWashington Derrick A · Louisville, KYBuilt 1999 · S/N E-3256 N452FRBonanza Valley LLC · Reno, NVBuilt 2012 · S/N E-3976 N452SCBond Jeffrey B · Lebanon, MOBuilt 1975 · S/N D-9771 N452SKAlcock Shane Vincent · Temple, TXBuilt 1972 · S/N 73-30522 N4530FBean David L · Chandler, AZBuilt 1966 · S/N 185-1015 N4532SElite Aviation Partners LLC · Blacklick, OHBuilt 1975 · S/N CE-598 N4533JStevens Investment Group LLC · Elsie, MIBuilt 1980 · S/N T18803745T N4533SBolanos Nilson J · Fairview, NJBuilt 1975 · S/N CE-612 N4534FSmith Peter A · Gunnison, COBuilt 1966 · S/N 185-1019 N4534SMarmon Robert A · Merion Station, PABuilt 1975 · S/N E-743 N4535FRohde Allen G · Eagle River, AKBuilt 1966 · S/N 185-1021 N4536KGowharrizi Ardeshir G · Los Angeles, CABuilt 1948 · S/N NAV-4-1536 N4537QInstant Security Service Inc · Wilmington, DEBuilt 1972 · S/N 402B0343 N4538FLohse Teal K · Cordova, AKBuilt 1966 · S/N 185-1025 N453BBBass Equipment LLC · Texarkana, ARBuilt 2016 · S/N TH-2453 N453MCMcneil Kenneth A · Fort Meade, FLS/N 21059844 N453MFSpain William D Jr · Mahopac, NYBuilt 1995 · S/N 29-0069 N453SAHts LLC · Hudsonville, MIBuilt 2002 · S/N E-3453 N4540Mathis Mark L · Fremont, CABuilt 1971 · S/N E-299 N4545MSimplifly Aviation LLC · Elon, NCBuilt 1978 · S/N TH-914 N4546FThomas Craig E · Stevensville, MTBuilt 1966 · S/N 185-1039 N4547MOxly Aviation LLC · Wilmington, DEBuilt 1978 · S/N TH-915 N4547SLorentz Aviation LLC · Canadian, TXBuilt 1976 · S/N TJ-81 N4548FWard Nelson H · Salcha, AKBuilt 1966 · S/N 185-1043 N4549FMetroaire LLC · Mc Kees Rocks, PABuilt 1966 · S/N 185-1045 N454GGAk Air Leasing LLC · Homer, AKBuilt 1981 · S/N U20606487 N454JDickey Michael W · Fredericksburg, TXBuilt 1979 · S/N E-1571 N454SPSps Investment Properties LLC · Macon, GABuilt 1980 · S/N 414A0626 N454SVEcliax LLC · Craig, AKBuilt 1981 · S/N U20606524 N4550QIsland Wings Inc · Fort Lauderdale, FLBuilt 1969 · S/N 402A0050 N4551SAak Enterprises LLC · Fayetteville, ARFirst renewal noticeBuilt 1976 · S/N CE-645 N4554FFejes Jacob J · Watertown, NYS/N 185-1057 N4556MPerry Richard H · Crossville, TNBuilt 1978 · S/N E-1234 N4557FKincaid Jonathan A · Frankfort, MEBuilt 1966 · S/N 185-1061 N4557NWestra Aviation LLC · Beaver Dam, WIBuilt 1978 · S/N 340A0547 N4558FN4558f LLC · Columbus, OHBuilt 1966 · S/N 185-1062 N4559MSky High Ventures LLC · Bartlett, TNS/N E-1235 N455BDArchco II LLC · Bloomfield, NEBuilt 2004 · S/N 1029 N455CDSanta Barbara Biplane Tours LLC · Santa Barbara, CABuilt 2004 · S/N 0907 N455DSanders Tyler B · Yuma, AZBuilt 1989 · S/N CE-1408 N455DCAviation Safety Training International LLC · Butte, MTBuilt 1968 · S/N CJ-13 N455FPRobert Corio Inc · Johnston, RIS/N TE-549

Back to AD 86-13-04 R3