Registered aircraft · 72,007

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-10-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:87-10-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:87-10-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:87-10-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:87-10-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:87-10-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.

N360LCHeidebrink Ronald E · West Chester, OHBuilt 1993 · S/N 674-320-418FB N360LHHenney Lawrence L · Granbury, TXBuilt 1998 · S/N FB417 N360LSLopez Gabriel A Trustee · El Monte, CABuilt 1996 · S/N 20190 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 N360XTThorall Patrick A · Chugiak, AKBuilt 2023 · S/N PT003 N360ZRN360zr LLC · Jacksonville, FLBuilt 1999 · S/N 749320591FB 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 N3611BRestorations & Rentals LLC · Tulsa, OKBuilt 1970 · S/N 27-4579 N3611HTavalaro Joseph DBA · Massapequa, NYBuilt 1977 · S/N 20-1247 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 N3612WKard Aviation LLC · Greenville, SCBuilt 1966 · S/N 32-513 N36134Manning John W · Floyds Knobs, INBuilt 1978 · S/N 28-7816615 N36137Big Bend Community College · Moses Lake, WABuilt 1973 · S/N 542-73 N36138Smith Brian Lee · Solvang, CABuilt 1973 · S/N 382-73 N36139Flying Sportsmen Inc · Sussex, NJBuilt 1973 · S/N 105-73 N3613NBradbury Kevin Earl · Saint George, UTBuilt 1967 · S/N 680011 N3613PLittle Bear Air LLC · Lubbock, TXS/N 22-3339 N3613WTurner Travis · Chetek, WIS/N 32-514 N36141Averill Terry B · Litchfield, MEBuilt 1973 · S/N 544-73 N36149Gilbert Paul · Diamondhead, MSBuilt 1978 · S/N 32R-7885165 N3614QMay Robert L · Spring Branch, TXBuilt 1967 · S/N MB-252

Back to AD 87-10-06 R1