Registered aircraft · 5,102

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-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N492BCConsumer Collection Management Inc · Saint Louis, MOBuilt 2005 · S/N 3255037 N4931WPerry Clifton · Lacon, ILBuilt 1977 · S/N 14254 N4934WS&T Aircraft LLC · Lewes, DEBuilt 1977 · S/N 14256 N4942FBarton Investment LLC · Salt Lake City, UTBuilt 1976 · S/N 32R-7680490 N4947FKpw Enterprises Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680492 N494MBMulhearn Walter F · Conroe, TXBuilt 1980 · S/N 32R-8029056 N495JBVan Bortel Aircraft Inc · Arlington, TXBuilt 2004 · S/N T18208284 N495WFWalters Steven M · Marathon, FLBuilt 1995 · S/N 3213097 N4960250 Inc · Washington, DCS/N 24-4025 N4960FLc Aviation LLC · Fort Meade, FLS/N 32-7640123 N4966FDj&A Enterprises LLC · Sevierville, TNBuilt 1976 · S/N 32R-7680494 N4976WQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 14296 N4981WJahn Kenneth Kris · Shingle Springs, CABuilt 1977 · S/N 14301 N4983WPappa Whiskey Victor LLC · Brandon, MSBuilt 1977 · S/N 14303 N498MMLadd Air LLC · Mt Holly, NCS/N 4636149 N4995WAnderson Ryan L · Wadena, MNS/N 14315 N499FCFoxtrot Charlie Aviation LLC · Charlotte, NCBuilt 1976 · S/N 32R-7780076 N49BMHarriman Aviation LLC · Pearland, TXBuilt 1977 · S/N 27-7754077 N49DSSalinger David L · Verdi, NVBuilt 1998 · S/N 27-0251 N49FMRockin R&L Ranch · Kaufman, TXBuilt 1999 · S/N 27-0260 N49LBOwen Walter M · Arlington, TNBuilt 1976 · S/N 32R-7680481 N49RDDziak Chester · Jackson, MIBuilt 1966 · S/N 27-3192 N4AVSouthwest Aircraft LLC · Fairacres, NMBuilt 1949 · S/N NAV-4-1844 N4DRTotah John E · Kailua Kona, HIBuilt 1966 · S/N 27-3175 N4EPPilots Landing Aviation LLC · Lampasas, TXBuilt 1979 · S/N 70032 N4QSPonderosa Aviation LLC · Safford, AZBuilt 1968 · S/N 1755-1 N4SGCp Aero LLC · Missoula, MTBuilt 2002 · S/N 3257282 N4VSAircraft Montana LLC · Helena, MTBuilt 1974 · S/N 27-7405426 N4WBBe Positive Holdings LLC · Bloomsburg, PABuilt 1977 · S/N 32R-7880018 N5008AWings Like Eagles LLC · Wilmington, DES/N 27-3695 N500EGElliott Candice H Brown · Santa Rosa, CABuilt 1974 · S/N 27-7405453 N500GWFeldtman Enterprises Inc · Wilmington, DEBuilt 1964 · S/N 1476-170 N500HMTalos Aviation Group LLC · Blackstone, VABuilt 1973 · S/N 3155 N500HRDese Enterprises LLC · Huntsville, ALBuilt 1981 · S/N 318152133 N500LCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954060 N500QSanborn Map Co Inc · Colorado Springs, COBuilt 1973 · S/N 31-7300934 N500TDPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7854027 N5014TGalati David R · Sebring, FLBuilt 1972 · S/N 32-7240098 N5015HKnox Fred · Los Altos, CABuilt 2001 · S/N T18208096 N501BCJamestown Jet Center Inc · Jamestown, NDBuilt 1973 · S/N 27-7305157 N501BTCloud Chasers LLC · Columbus, MSBuilt 1976 · S/N 32R-7780039 N5020ABrown Jonathan Corey · Sherman Oaks, CABuilt 2001 · S/N T18208097 N5033TJulol Investments LLC · Miami, FLBuilt 2005 · S/N T18208454 N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165 N503VFC&H Aviation LLC · Greenwood Village, COBuilt 2003 · S/N 3255004 N505HVHelivision LLC · Concord, NCBuilt 2000 · S/N T20608152 N505JWCampbell Matthew P · Visalia, CABuilt 1975 · S/N 75-31118 N5061CMatheny Robert Gregg · Kingman, AZBuilt 2002 · S/N T18208166 N5066HDohr William F · Williamsburg, VABuilt 2001 · S/N T18208098 N506CVail Jeffrey · Kennett Square, PABuilt 2004 · S/N 3255015

Back to AD 81-12-06 R1