Skip to content

Registered aircraft · 18,497

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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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.

N3808QJordan Klein DBA · Summerfield, FLS/N CE-936 N380CDTomlinson Consulting LLC · Columbia, MDBuilt 2005 · S/N 1380 N380MMFolk Daniel H · Urbana, ILBuilt 1995 · S/N 29-0068 N380PCRhomberg Bernard B · Elm Grove, WIBuilt 1978 · S/N E-1384 N3810CBlake Thomas C · Vero Beach, FLBuilt 1981 · S/N TJ-335 N3810ZFalcon Ridge Industries Inc · Milleville, NJBuilt 1980 · S/N E-1802 N3813GOne Three Golf LLC · Cleghorn, IABuilt 1977 · S/N 310R0916 N3813QBemowski Paul · Madison, WIBuilt 1981 · S/N EA-187 N3813YSheppard David A · Jackson, CABuilt 1964 · S/N 21058313 N3814YLadner Donald E · Centerville, TXS/N 21058314 N3815KShoemaker James W · Hilltop Lakes, TXBuilt 1980 · S/N CE-939 N3815PNorth Louisiana Aviation LLC · Mer Rouge, LABuilt 1981 · S/N E-1850 N3815YBorean Anthony J · Olathe, COBuilt 1964 · S/N 21058315 N38168Jjj&S Aviation Corp · Brooklyn, NYBuilt 1981 · S/N E-1808 N3816SKey Field Flyers LLC · Toomsuba, MSBuilt 1981 · S/N E-1806 N38175Fhg Springbrook Corp · Wilmington, DEBuilt 1981 · S/N CE-940 N3817MGulf Skies LLC · Kalispell, MTBuilt 1981 · S/N EA-191 N3819YLaycock Justin D · Johnson City, TNBuilt 1964 · S/N 21058319 N381ACKarter Transport Enterprise LLC · Monterey, CABuilt 2007 · S/N E-3759 N381CDN381cd Aviation LLC · Ventura, CABuilt 2005 · S/N 1432 N381CRSiemsen Randall R · Clovis, CABuilt 1976 · S/N E-875 N381DSFlightpath Investments LLC · Ottumwa, IABuilt 1974 · S/N 21060255 N381LMorgan Fred M · Onancock, VABuilt 1999 · S/N 29-0201 N381SBettys Beech LLC · Conway, ARBuilt 1968 · S/N TE-629 N381TCShumate Frank T · Rockport, TXBuilt 1978 · S/N TK-83 N3820LFly A Twin LLC · Kirkland, WABuilt 1981 · S/N TJ-341 N3821GI Am Alpha & Omega LLC · Sparks, NVS/N U206-0821 N3822KPerry Park Investments Inc · Larkspur, COBuilt 1981 · S/N EA-192 N3822URegistration Pending · Stillwater, MNRegistration pendingBuilt 1981 · S/N D-10364 N3823AAndy Downs LLC · Langdon, NDBuilt 1981 · S/N EA-194 N3824XHirschauer Jeffrey · Spokane, WABuilt 1981 · S/N CE-941 N3824YMclaren Richard T · Sturbridge, MABuilt 1964 · S/N 21058324 N3825MMckendry Scott P · Sanford, NCBuilt 1981 · S/N E-1813 N3825XBliss Aviation LLC · Somerville, TNBuilt 1981 · S/N TH-1230 N3825YAtlas Mining & Mechancial Inc · Beryl, UTBuilt 1964 · S/N 21058325 N3827QCobb Jeff B · Atlanta, GABuilt 1981 · S/N CE-942 N3827YPrentice Ronald L · Winchester, CABuilt 1964 · S/N 21058327 N38282Zemetis Terence A · Meriden, CTBuilt 1981 · S/N E-1819 N3828NSallustio Eric · Lake Butler, FLBuilt 1981 · S/N E-1818 N3828YHall Edmond · Bremerton, WABuilt 1964 · S/N 21058328 N3829PRalphs Thomas A · Solana Beach, CABuilt 1978 · S/N P21000062 N382CBMoncada Ramos Edwin Antonio · Lawrenceburg, KYBuilt 1974 · S/N 75-30731 N382CDLakeview Aviation LLC · Middletown, DEBuilt 2005 · S/N 1390 N382CRSkyport Aviation LLC · Oxford, MIBuilt 1982 · S/N T30300096 N382MCShiver James B · Stanley, NMS/N 421B0452 N382MGMissionary Air Group Inc · Burlington, NCBuilt 1979 · S/N U20605256 N382SHernandez Luis A · Longview, TXBuilt 1966 · S/N TE-166 N3830GAerial Transport LLC · Dover, DES/N U206-0830 N3830YRice Kevin L · Pleasant View, COBuilt 1964 · S/N 21058330 N3831GPanepinto Lane L · Lafitte, LAS/N U206-0831

Back to AD 86-13-04 R3