Skip to content

Registered aircraft · 3,961

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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N5768MHeal Your Heart LLC · Redding, CABuilt 1968 · S/N 310P0068 N5768S3c LLC · Waukee, IABuilt 1972 · S/N 3400037 N5769XHagemeier Justin · Memphis, TNBuilt 1961 · S/N 320-0069 N5770MBallard Aviation Inc · Newton, KSFirst renewal noticeBuilt 1968 · S/N 310P0070 N5779XDirigo Aerospace Solutions LLC · Sumner, MES/N 320-0079 N577KGMccloy Mark T · Tatum, NMS/N 421C0906 N577RJAviation Trust Company LLC · Oklahoma City, OKBuilt 1981 · S/N 421C1108 N577SWAir Plains Services Corp · Wellington, KSS/N 421-0023 N5780XWilton William H · Kailua Kona, HIBuilt 1961 · S/N 320-0080 N5781MRudnik Andrew S · Ann Arbor, MIBuilt 1969 · S/N 310P0081 N5782MGingell Robert A · Sunnyvale, CABuilt 1969 · S/N 310P0082 N5783MBig Turbine Engines LLC · Wilmington, DEBuilt 1969 · S/N 310P0083 N5788XMcmahan William K · Sandy Valley, NVBuilt 1962 · S/N 320-0088 N5793MCoxbill Farms Inc · Torrington, WYBuilt 1969 · S/N 310P0093 N5793XSchmick Kenneth Richard · Fond Du Lac, WIS/N 320-0093 N5794MMatlach Matthew · Brandon, FLBuilt 1969 · S/N 310P0094 N57BWNorthwoods Airlifeline Ltd · Kingsford, MIBuilt 1968 · S/N 310N-0154 N57PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0300 N57WAE2 Hangar LLC · Folsom, CAS/N 421C0451 N5800MRidgewood Associates Inc · Nevada City, CAS/N 310P0100 N5806XJohnson Joseph S · Juneau, AKBuilt 1961 · S/N 310-0106 N5812XAll-Bid Inc · Opelousas, LABuilt 1961 · S/N 310-0112 N5814XEberly Steven K · Euless, TXBuilt 1961 · S/N 310-0114 N5816MHolloway Aero LLC · Chino Hills, CAS/N 310P0116 N5817MHonan William · Rainbow City, ALBuilt 1969 · S/N 310P0117 N5818MGlidepath Aviation LLC · West Jordan, UTBuilt 1969 · S/N 310P0118 N5819MJones Kathleen W · Springfield, ORBuilt 1969 · S/N 310P0119 N581CJDodson International Parts Inc · Rantoul, KSS/N 421B0343 N5821MMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0121 N5822XTas Aviation Of Defiance Inc · Defiance, OHBuilt 1961 · S/N 310-0122 N5825MLee Brian P · Kent, WABuilt 1969 · S/N 310P0125 N5826CBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 402C0050 N5827MHopland Steve · Johnson City, TNBuilt 1972 · S/N 340-0051 N5827XBechtold Norman J · Claremore, OKBuilt 1961 · S/N 3100127 N5833XOttley Adam James · Montague, CAS/N 310-0133 N583DWKinetic Systems Inc · Richmond Hill, GABuilt 1973 · S/N 421B0583 N5843MEastern Aero LLC · Gibsonville, NCBuilt 1969 · S/N 310P0143 N5843XPierson Janice R Trustee · Scio, ORS/N 310-0143 N5845MPointhigh Partners Lp · Dallas, TXBuilt 1969 · S/N 310P0145 N5845XCranton Larry J · Mesa, AZBuilt 1961 · S/N 310-0145 N5850MJones Michael J · Cypress, TXBuilt 1969 · S/N 310P0150 N5853XAnderson Douglas S · Gansevoort, NYBuilt 1961 · S/N 310-0153 N5854MJantzen Equipment LLC · Madrid, NEFirst renewal noticeBuilt 1969 · S/N 310P0154 N5857MVenturi Corp · Staunton, ILBuilt 1969 · S/N 310P0157 N5859MJasper County Properties LLC · Jasper, TXBuilt 1972 · S/N 340-0057 N5862MPortland Holdings LLC · Vista, CABuilt 1969 · S/N 310P0162 N5868CShimomura & Co Cpas Pc · New York, NYBuilt 1980 · S/N 340A0977 N586JRHuerta Holdings Inc · Santa Ana, CABuilt 1969 · S/N 310P0165 N5870MMcdonald Brian L · Van Alstyne, TXBuilt 1972 · S/N 3400058 N5872MDixon Jack · Casa Grande, AZBuilt 1969 · S/N 310P0172

Back to AD 87-21-02 R1