Registered aircraft · 22,416

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.

N9385CRobinson Steven Christopher · Enid, OKS/N 32R-7885046 N9385JDauzat Robbie A · Pineville, LABuilt 1966 · S/N 28-3485 N9386JWilkes Flying Club Inc · Wilkesboro, NCBuilt 1966 · S/N 28-3486 N9386NMays David J · Lincolnton, NCBuilt 1969 · S/N 28R-35096 N9387JBetzold Michael K · Anchorage, AKBuilt 1966 · S/N 28-3488 N9389JRaymer Michael D · Paris, TNBuilt 1966 · S/N 28-3490 N9389WLewis William Blair · Powell, OHFirst renewal noticeBuilt 1968 · S/N 28-11085 N9390JBrittle Aviation LLC · Chapel Hill, NCBuilt 1966 · S/N 28-3491 N9390NDenison Flying Club LLC · Denison, IABuilt 1969 · S/N 28R-35100 N9391JDonnell Roland G · Dallas, TXBuilt 1966 · S/N 28-3493 N9391WNunez Jesus · Somerton, AZS/N 28-11087 N9392CThompson Terry · Lake Placid, FLBuilt 1978 · S/N 28-7816471 N9392JChaney Paul A · Oklahoma City, OKBuilt 1966 · S/N 28-3494 N9392KDevils Lake Aero LLC · Devils Lake, NDBuilt 1976 · S/N 32R-7680219 N9392NWilder Bradley Alton · Cypress, TXBuilt 1969 · S/N 28R-35102 N9392WSatorius Matthew · Crestview, FLBuilt 1968 · S/N 28-11088 N9393JFox Wendell B Jr · Plains, KSBuilt 1966 · S/N 28-3496 N9393WAristigue Danny · Sierra Vista, AZS/N 28-11089 N9394JMilligan Stephen K · Timmonsville, SCFirst renewal noticeBuilt 1966 · S/N 28-3497 N9394NWeller James Alan · Barnesville, GABuilt 1969 · S/N 28R-35104 N9394WLeading Edge Scaffold Inc · Las Vegas, NVBuilt 1968 · S/N 28-11091 N9395JGuss Dwight L · Eastsound, WABuilt 1966 · S/N 28-3499 N9396CShaw Kent E · Gaithersburg, MDBuilt 1978 · S/N 28-7816472 N9396JCorporate Aviation Services LLC · Stockton, CABuilt 1966 · S/N 28-3500 N9397CServant Air Ministries Inc · Merritt Island, FLBuilt 1978 · S/N 28-7890409 N9397JTaylor Kyle O · Remlap, ALBuilt 1966 · S/N 28-3501 N9397WFAA Flying Club Inc · Springfield, VABuilt 1968 · S/N 28-11094 N9398NCraige Danny D Trustee · Durant, OKBuilt 1969 · S/N 28R-35109 N9399NYankcub LLC · North Charleston, SCBuilt 1969 · S/N 28R-35110 N939EQDuclos Excavating Inc · Red Bud, ILBuilt 1972 · S/N 28-7305162 N939GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881079 N939RJUaa International Inc · La Verne, CABuilt 1998 · S/N 2843136 N93CCRps Aviation Group LLC · Slinger, WIBuilt 1977 · S/N 28R-7803157 N93KCT I M E Flight Inc · Heber Springs, ARBuilt 1992 · S/N 3213041 N93KNPataky Gabriel J · Sarasota, FLBuilt 1993 · S/N 2890174 N93PNHawkins Steven L · Grand Prairie, TXBuilt 1974 · S/N 32-7440091 N93TJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28R-35026 N93VBSky Blue Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887176 N93WPHbfc Inc · Tehachapi, CABuilt 1964 · S/N 28-20460 N93WRDukic Slobodan · Jacksonville, FLBuilt 1977 · S/N 28-7890106 N9400JRobinson William L · Buckeye, AZS/N 28-3505 N9400KSyvanen Janne M · Staten Island, NYBuilt 1976 · S/N 28-7625179 N9400WLow Wing Aviation LLC · Mountain Home, ARBuilt 1968 · S/N 28-11105 N9401CRegistered aircraftBuilt 1978 · S/N 28R-7837197 N9401LAustin Aviators Flight Club · Austin, TXBuilt 1968 · S/N 28-11106 N9401NJanes Charles Dale · Cleburne, TXBuilt 1969 · S/N 28R-35112 N9402JHigh Flight Flying Club LLC · Reston, VABuilt 1966 · S/N 28-3508 N9402KCash Management Consulting LLC · Granite Springs, NYBuilt 1976 · S/N 28-7615200 N9404JCordice Jearohan Giles · Fort Worth, TXBuilt 1966 · S/N 28-3510 N9404KJmy Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 28-7615201

Back to AD 87-08-08 R3