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.

N501MLVotava Paul A · Mcintosh, MNBuilt 1970 · S/N TH-72 N501NANasa Langley Research Center · Hampton, VABuilt 2001 · S/N 0012 N501PFTraumflieger LLC · Lancaster, PABuilt 2001 · S/N 40021 N501SBStevenson Randall J · Wildwood, MOS/N 310R0166 N501SFNomarco Inc · Woodburn, ORS/N 21061808 N5021JIntegrity Aviation LLC · Coatesville, INBuilt 1976 · S/N 310R0803 N50233Garofalo Dawn L · Bellingham, WABuilt 1972 · S/N U20601911 N5023FCharlie Tango Enterprises LLC · Newport Beach, CABuilt 2004 · S/N 0842 N5025WAdvanced Aircraft Engineering Inc · Amelia Island, FLBuilt 2001 · S/N EA-677 N5026AMartin Kent D · Pittsburg, TXBuilt 2014 · S/N TH-2426 N5026UBorders Nowell Equipment G P Inc · Edinburg, TXBuilt 1963 · S/N 206-0026 N5026VPiland Kenneth Eldon Jr · Carlsbad, CABuilt 1975 · S/N 21060822 N5028RSmith Ray C Jr · Sault Sainte Marie, MIBuilt 1976 · S/N 18502981 N502ATAir Note LLC · Delray Beach, FLBuilt 1973 · S/N 421B0547 N502BZBirchfield Randy R · Wakeman, OHBuilt 2005 · S/N 1485 N502CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1149 N502JJMrch Airways Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1970 · S/N 414-0061 N502RARichland Aviation Inc · Sidney, MTBuilt 1977 · S/N 4040066 N502TJBasden Richard A · Dallas, TXBuilt 1973 · S/N CE-468 N5030DGuerra Mark David Francisco Maduro · Key Biscayne, FLBuilt 2014 · S/N E-4030 N5030SPolaris Fire Protection Inc · Fernandina Beach, FLBuilt 2004 · S/N 0827 N5033JSol Aerial Surveys LLC · Las Vegas, NVBuilt 1974 · S/N 310R0153 N5036M66ee LLC · Santa Barbara, CABuilt 1978 · S/N E-1255 N5036UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N TH-2362 N5037QSayler Ben · Thief River Falls, MNBuilt 1971 · S/N 340-0012 N5037VPoh Enterprises LLC · Gardena, CABuilt 1975 · S/N 21060824 N5038JKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 310R0158 N5038RKnecht Ken L · Eagle River, AKBuilt 1976 · S/N 18502985 N503ATRegistered aircraftBuilt 1975 · S/N 21060924 N503BNAllegrezza Fred · Line Lexington, PABuilt 2005 · S/N 1276 N503CDLagade Marco C · Lake Mary, FLBuilt 2004 · S/N 0909 N503MDChristy John R · Anchorage, AKBuilt 1963 · S/N 206-0076 N503RAAirplanes And Coffee LLC · Kalispell, MTBuilt 2001 · S/N 40024 N5040UAir Data Solutions LLC · Natchitoches, LABuilt 1963 · S/N 206-0040 N5045DFisher Ranch LLC · Blythe, CABuilt 2014 · S/N E-4045 N5046RSandpoint Aviation LLC · Sandpoint, IDS/N 18502988 N5047JAir Transport Arm Of Christ Inc · Hurst, TXBuilt 1975 · S/N 310R0167 N504FPBaumgarten Jeffrey A · New Orleans, LABuilt 2004 · S/N 1192 N504GLBravo Whiskey Solutions LLC · Brenham, TXBuilt 1975 · S/N TJ-26 N504JCFrequent Flyer LLC · Manasquan, NJBuilt 1973 · S/N 18502155 N504JWPalmer Gary H · San Juan, TXBuilt 1981 · S/N 21064232 N504QChelatna Lake Lodge LLC · Anchorage, AKS/N U2061293 N504SJAmerican Bonanza Society Air Safety Foundation Inc · Wichita, KSBuilt 1981 · S/N E-1849 N504WEArchitectural Supplements Aviation LLC · Waterbury, CTBuilt 2016 · S/N TH-2454 N5050GHats Off Aviation LLC · Newnan, GABuilt 2004 · S/N 0833 N5050LFrederick Benjamin J · The Woodlands, TXBuilt 1977 · S/N E-986 N5053JClo Corp · Wilmington, DEBuilt 1974 · S/N 310R0173 N5056XN5056x LLC · Troy, OHS/N E-3456 N5058USkyler Aviation Inc · San Diego, CABuilt 1963 · S/N 206-0058 N505CDValiair Limited Company Owner Trustee · Casper, WYBuilt 2002 · S/N 0323

Back to AD 86-13-04 R3