Skip to content

Registered aircraft · 6,238

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-18-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-18-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-18-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-18-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-18-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-18-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.

N913QWA Parrotte'S View In Flight LLC · Wilmington, DEBuilt 1991 · S/N CE-1602 N9140QTonka Seaplanes LLC · Minnetonka, MNBuilt 1971 · S/N D-9235 N9140STregellas Tim E · Aledo, TXBuilt 1976 · S/N D-9861 N9141QBear Air LLC · Elizabeth City, NCBuilt 1970 · S/N CE-317 N9141SZuckerman Charles J Trustee · San Diego, CABuilt 1976 · S/N CE-632 N9142QLamb Christopher A · Perry, OKBuilt 1971 · S/N CE-338 N9143QCarlson Jeffrey K · Lake Stevens, WAS/N D-9236 N9144QN9144q LLC · Brooklyn, NYBuilt 1970 · S/N E-250 N9145QWest Thomas P Jr · Bridgeport, OHBuilt 1971 · S/N TE-834 N914BSSchwartzman Blake R · Las Vegas, NVBuilt 1991 · S/N CE-1579 N9153QHansing Frederick Christopher · Moorpark, CABuilt 1970 · S/N D-9239 N9154QBuck Air LLC · Dover, DEBuilt 1971 · S/N CE-318 N9155QPeters William B · Vienna, WVBuilt 1970 · S/N CE-319 N9158QBurton John H III · Woodstock, ILBuilt 1970 · S/N D-9217 N9164QFletcher Mountain Aviation LLC · Hampden, MEBuilt 1971 · S/N CE-323 N9169QMedic Choppers LLC · Springdale, ARBuilt 1970 · S/N E-253 N916BCN916bc LLC · Woodward, OKBuilt 1988 · S/N E-2448 N916JWSouth Delta Aviation Inc · Fayetteville, ARBuilt 1976 · S/N TJ-91 N9170QKing Air Properties LLC · Huntington Beach, CABuilt 1971 · S/N CE-327 N9171QBeech Babe Ltd · Colorado Springs, COBuilt 1970 · S/N D-9246 N9177QPapst Bonanza LLC · Parker, AZBuilt 1970 · S/N E-257 N9177ZShine Transportation Leasing LLC · Winchester, VABuilt 1979 · S/N CE-853 N9179QDewitt Weldone · Brashear, TXBuilt 1971 · S/N CE-331 N9179XJohnson Randolph B · Wichita Falls, TXBuilt 1992 · S/N E2759 N917DCRegistered aircraftFirst renewal noticeBuilt 1981 · S/N E-1884 N917JKJen-Kel Aviation LLC · Sarasota, FLBuilt 1975 · S/N E-652 N917MPPool Shark Equipment LLC · Memphis, TNBuilt 1981 · S/N TH-1243 N917SDTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9988 N917TRTry Trying Management And Promotions LLC · Indianapolis, INS/N TH-133 N9183BSteller Aviation LLC · Middletown, DEBuilt 1991 · S/N E-2631 N9186QGaines Norse · Irvine, CABuilt 1971 · S/N CE-332 N9192QMonroe Aviation Inc · Verona, PABuilt 1971 · S/N E-259 N9195QMeadowlake Airpark LLC · Lenoir City, TNBuilt 1971 · S/N TH-152 N9199QCramer Todd L · Fort Mohave, AZBuilt 1971 · S/N CE-334 N919BGFreebird Aviation LLC · Monahans, TXBuilt 1984 · S/N EA-428 N919CAvventura Del Volo LLC · Nashville, TNBuilt 2004 · S/N E-3563 N919DPTrumbull Thomas A Trustee · Leland, MIBuilt 1987 · S/N E-2373 N919JBWiz Air LLC · Wilmington, DEBuilt 1980 · S/N E-1702 N919MSStraits Mark · Sugarcreek, OHS/N E-3504 N919PJDel Rosso Peter · Los Angeles, CABuilt 1981 · S/N TK-140 N919TPWarren Jason J · Silverdale, WABuilt 1977 · S/N D-10068 N91DDLonghorn Leasing LLC · Anchorage, AKS/N EA-511 N91JPJackson Gerald M · Lake City, MIBuilt 1975 · S/N D-9810 N91JRSpring Mountain Properties LLC · Fort Smith, ARBuilt 1973 · S/N TH-313 N91KMj Aviation Inc · Custer, SDBuilt 1975 · S/N D-9764 N91WMN2sb LLC · Southlake, TXBuilt 1983 · S/N TH-1396 N91YRRegistered aircraftBuilt 1991 · S/N CE-1634 N9200QHenning Lowell W · Haslet, TXBuilt 1971 · S/N CE-335 N9203QDavis & Automotive Services Inc · Carlinville, ILBuilt 1971 · S/N E-261 N920CBOgden Newspapers Inc · Wheeling, WVBuilt 1981 · S/N TJ-380

Back to AD 87-18-06 R1