Registered aircraft · 81,733

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:81-18-04-R2') 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-04-R2') 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:81-18-04-R2')
    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-04-R2')
  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:81-18-04-R2')
  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-04-R2')
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.

N360JH360jh LLC · Pompton Plains, NJBuilt 1992 · S/N 580 N360JWWomack Jay A · Jackson, LABuilt 1992 · S/N 200-031 N360KLCarrara Dean E · Aiken, SCS/N 1 N360KMOgston Kai D · Colbert, WABuilt 2009 · S/N 001 N360KSSavier Helmut Klaus · Santa Paula, CABuilt 2010 · S/N SEZ-1 N360LCHeidebrink Ronald E · West Chester, OHBuilt 1993 · S/N 674-320-418FB N360LDJohnson John · Omaha, NEBuilt 1954 · S/N 22-2335 N360LHHenney Lawrence L · Granbury, TXBuilt 1998 · S/N FB417 N360LSLopez Gabriel A Trustee · El Monte, CABuilt 1996 · S/N 20190 N360LULewis University · Romeoville, ILBuilt 2021 · S/N 4496522 N360LWOwens Waylon D · Buckley, WABuilt 1997 · S/N 4155 N360MEB L T 360 Aviation LLC · Dalhart, TXBuilt 2000 · S/N 18280849 N360MFBecker James C Trustee · Whitefish Bay, WIBuilt 2003 · S/N 0036 N360MHAcme Racing LLC · Overland Park, KSBuilt 1993 · S/N L-32979-36A N360MLCox Allen W Jr · Clarkton, NCBuilt 1997 · S/N 001 N360MSPiggott Russ · Fresno, CABuilt 1998 · S/N 2290 N360NCSap Aero Leasing LLC · Littleton, COBuilt 2024 · S/N 2376 N360PGarman Jonathan D · Reno, NVS/N 256-24 N360PBBelleville Marcel · New Port Richey, FLBuilt 2008 · S/N 522-320-260FB N360PSEllis Nigel R · Concord, CAS/N 01 N360QBSpirit Of Flight Foundation · Nampa, IDS/N DE1002 N360RGJay Services LLC · Stephenville, TXS/N 382 N360RHMunson Bruce E · Little Rock, ARBuilt 1999 · S/N 956-320-796 N360RTN360rt LLC · Lewes, DEBuilt 2005 · S/N 834-320-676 N360SBYoung Dennis L · Fort Worth, TXBuilt 1978 · S/N 32R-7885159 N360SPN360sp LLC · Palm City, FLBuilt 2001 · S/N 172S8777 N360SRRegistration Pending · Pleasant Grove, CARegistration pending, pending cancellationBuilt 1994 · S/N 20997 N360SXSkrock David G · Grants Pass, ORBuilt 2012 · S/N 980-320-820 N360TNSamaritan Aviation · Mesa, AZBuilt 1990 · S/N 1026 N360WBBaumann Wayne R · Waterford, MIBuilt 1999 · S/N 23085 N360WSWood Scot L · Irvington, ALBuilt 2014 · S/N 1482 N360WY360wy LLC · Pinedale, WYBuilt 2014 · S/N BC21405001 N360XKPoore Curby W · Mcdonald, KSS/N 435-320-185 N360XPBaker Laurence Todd · Imlay City, MIBuilt 1990 · S/N 566 N360XSFoster Aviation And Mobile Maintenance LLC · Dublin, VABuilt 2002 · S/N 908 N360XTThorall Patrick A · Chugiak, AKBuilt 2023 · S/N PT003 N360XXSleepy Dog LLC · Sheridan, WYBuilt 2012 · S/N 06-522 N360YBBeato Ronil · Plant City, FLBuilt 2019 · S/N 510-320-248 N360ZRN360zr LLC · Jacksonville, FLBuilt 1999 · S/N 749320591FB N3610ADid U Die Inc · Herrin, ILBuilt 1953 · S/N 22-1870 N3610HScheffing Glenn J · Palm Beach Gardens, FLBuilt 1977 · S/N 20-1246 N36115Turner Randall D · Tolar, TXBuilt 1978 · S/N 28-7816613 N36116Meriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816614 N36118Cg Aviation LLC · Woods Cross, UTFirst renewal noticeBuilt 1978 · S/N 28-7890495 N3611HTavalaro Joseph DBA · Massapequa, NYBuilt 1977 · S/N 20-1247 N3611MPozanac Charles J · Riverside, CABuilt 1947 · S/N 12-2543 N3611NDowden Frank D · Fallbrook, CABuilt 1967 · S/N 680010 N36120United States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837266 N36129Tjarks Heyo H · Dubuque, IABuilt 1978 · S/N 32R-7885164 N3612PGoundry George D · Sammamish, WABuilt 1955 · S/N 22-3338

Back to AD 81-18-04 R2