Skip to content

Registered aircraft · 22,413

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

N6525WJackson Donald W · Carthage, MSBuilt 1964 · S/N 28-20604 N6526JMcfeeters Milena · Madison, WIBuilt 1968 · S/N 28-4964 N6527JHaverporth Daniel L · Las Cruces, NMBuilt 1968 · S/N 28-4965 N6527WEnsminger Joseph · Manchester, MOBuilt 1965 · S/N 28-20606 N6528WCampbell Joshua S · Sugarcrk Twp, OHBuilt 1964 · S/N 28-20607 N6529CRainey David K · Franklin, TXBuilt 1978 · S/N 28-7816433 N652FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020170 N6530JSalmon Woody W · Chalkyitsik, AKBuilt 1968 · S/N 28-4969 N6531CDorr Juergen W · Mundelein, ILBuilt 1978 · S/N 28-7890380 N6531JLoehrer Daniel J · Milbank, SDBuilt 1968 · S/N 28-4970 N6532CQuartarolo Pete · Santa Rosa, CABuilt 1978 · S/N 28-7890381 N6533JPaulson James L · Lawrenceville, NJBuilt 1968 · S/N 28-4973 N6533W21 Luna LLC · Phoenix, AZBuilt 1965 · S/N 28-20612 N6534CMccarthy John P · Lutz, FLBuilt 1978 · S/N 28R-7803235 N6536JCooper David M · Sedona, AZS/N 28-4977 N6536WDenny David F · Bath, NCS/N 28-20615 N6537JTimer Anna Mae · Wildwood Crest, NJBuilt 1968 · S/N 28-4978 N6538JBerra Robert J · Burtonsville, MDS/N 28-4980 N6539WYounglove Donald L · Mendota, ILBuilt 1965 · S/N 28-20618 N653BQQuilty Stephen M · Abingdon, VABuilt 1968 · S/N 28-5055 N653FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020171 N6540WRiggs Charles A · Pembroke Pines, FLBuilt 1965 · S/N 28-21266 N6542WBaird Philip D · Judith Gap, MTS/N 28-21268 N6543WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-20622 N6546FMiljour Jack A · Sanborn, NYBuilt 1976 · S/N 28-7790153 N6547JMeyer Mark A · Vass, NCBuilt 1968 · S/N 28-4990 N6547WMacclements Jonathan E · Austin, TXBuilt 1965 · S/N 28-20626 N6548JInspire Aviation LLC · Magnolia, TXBuilt 1968 · S/N 28-4992 N6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeBuilt 1968 · S/N 28-4993 N654BCCobb Charles J · Fallbrook, CABuilt 1969 · S/N 28-5335 N654FLRoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDBuilt 1971 · S/N 28-7125569 N654FTFlorida Institute Of Technology Inc · Melbourne, FLS/N 28020172 N654YRVet Air LLC · San Juan, PRBuilt 1964 · S/N 28-1867 N6550JJans Stanley E · Dakota City, NEBuilt 1968 · S/N 28-4994 N6551WThull Stanley B · Freeport, MNBuilt 1965 · S/N 28-20631 N6552JCherokee Flyers Inc · Phoenixville, PABuilt 1968 · S/N 28-4997 N6553FArcwin Aero LLC · New Palestine, INBuilt 1976 · S/N 28-7790154 N6553JCrestwater Properties LLC · Florence, SCBuilt 1968 · S/N 28-4998 N6554CCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7890383 N6554WTpc Air LLC · Colleyville, TXBuilt 1965 · S/N 28-20634 N6555WDeeter George E · Chillicothe, OHBuilt 1965 · S/N 28-20636 N6556JJabco Inc · Weston, IDBuilt 1968 · S/N 28-5002 N6556WMontagnino James A · Saratoga Springs, NYBuilt 1965 · S/N 28-20637 N6557JAsd LLC · Lebanon, NJBuilt 1968 · S/N 28-5003 N6557WFrederick Darin L · Star, IDBuilt 1965 · S/N 28-20638 N6558JKarr Dennis R · Clyde, OHBuilt 1968 · S/N 28-5004 N6558WShirley Hills Aviation LLC · Macon, GAS/N 28-20639 N6559WHarrison Michael W DBA · Lewisville, IDBuilt 1965 · S/N 28-20640 N655AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881755 N655MAFanning John F · Delaware, OHS/N 2843655

Back to AD 87-08-08 R3