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.

N5712JFree Air LLC · Helena, MTBuilt 1969 · S/N P20600612 N5713KJennings James H · Clovis, NMBuilt 1964 · S/N D-7513 N5713VCaribbean Dental Lab LLC · St Thomas, VIBuilt 1966 · S/N TE-98 N5715KChase Brandon C · Plains, KSBuilt 1964 · S/N D-7510 N5716JTaos Sky Flight School LLC · El Prado, NMBuilt 1969 · S/N P20600616 N5719KJohns Ricky · Joliet, ILBuilt 1964 · S/N D-7517 N5719VFox Will E · Los Alamos, NMBuilt 1966 · S/N D-8092 N571CDN&I Skies LLC · Leesburg, VABuilt 2005 · S/N 1659 N571DDennis Billy C Jr · Scottsdale, AZBuilt 1975 · S/N TE-1030 N571TXTravel Stiffs LLC · Madisonville, KYBuilt 1990 · S/N CE-1522 N5720KCrumpler Chad C · Wichita, KSBuilt 1964 · S/N D-7520 N5722VShank Joel F · Brawley, CABuilt 1966 · S/N CE-36 N5724VN5724v LLC · Kalispell, MTBuilt 1966 · S/N D-8103 N5725VCrumly Chris P · Woodlake, CABuilt 1966 · S/N CE-40 N5726KRegistered aircraftBuilt 1964 · S/N D-7571 N5727NQualitair LLC · MicheistadtBuilt 1977 · S/N 18503320 N5727VCulver Investments LLC · Gordon, TXBuilt 1966 · S/N D-8186 N5728VGlenn Metalcraft Inc · Princeton, MNBuilt 1966 · S/N CE-25 N5729MN5729m LLC · Coral Springs, FLBuilt 1972 · S/N 340-0038 N572BPThomas Andy K · Cary, NCBuilt 1983 · S/N CE-1019 N572CDWaite Aviation LLC · Xenia, OHBuilt 2005 · S/N 1663 N572EEcho Air LLC · Anchorage, AKBuilt 1972 · S/N 18502089 N572FGDrw Air Partners LLC · Tyler, TXBuilt 2008 · S/N E-3827 N572TPaterson Eric G · Blacksburg, VABuilt 1964 · S/N D-7400 N5730VBooher Tabitha O · Livingston, TNBuilt 1966 · S/N D-8101 N5731JPaulick Adam J · Deerfield, WIBuilt 1969 · S/N P20600631 N5731MZortman Micky P · Mexico, MOS/N 310P0031 N5732KAndrus Ralph · Denison, TXBuilt 1964 · S/N D-7518 N5732VErps Jason D · Blue Springs, MOBuilt 1966 · S/N D-8104 N5734BGrinnell Chris · Willis, TXBuilt 1956 · S/N BG-365 N5734VAranda Carlos Javier · Orange, CABuilt 1966 · S/N CE-28 N5735VRay Brian · Peoria, ILBuilt 1966 · S/N CE-29 N5736VLom-Ajan Vicente A · Plantation, FLS/N D-8105 N5737KNeubauer Accounting LLC · Wray, COBuilt 1964 · S/N D-7540 N5738VBailey Frederick D · Fayetteville, ARBuilt 1966 · S/N D-8109 N5739KLyn Alden Cleveland · Kansasville, WIBuilt 1964 · S/N D-7519 N573CDF R E Investments LLC · Enterprise, ALBuilt 2004 · S/N 1038 N573JCCoffey John L · Iron River, WIS/N 18502396 N5740MSiemens Jonathan · Seminole, TXBuilt 1968 · S/N 310P0040 N5741VSjr Properties LLC · Reno, NVBuilt 1966 · S/N D-8106 N5742MAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1968 · S/N 310P0042 N5742VAllen Bruce C · Anna, TXBuilt 1966 · S/N D-8111 N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643 N5745KGreen Mountain Avionics Inc · Middlebury, VTBuilt 1964 · S/N D-7555 N5745VBonanza N5745v LLC · Colorado Springs, COBuilt 1966 · S/N D-8187 N5747KDel Martin Lp · Spring, TXBuilt 1964 · S/N D-7534 N5749KBase To Final LLC · Mesa, AZBuilt 1964 · S/N D-7536 N574CDMassingale Harold L · Lenoir City, TNBuilt 2005 · S/N 1554 N574HALow Approach LLC · Wilmington, NCBuilt 2001 · S/N TH-1975 N574JPThompson Phillip · Lakeway, TXBuilt 1977 · S/N D-10054

Back to AD 86-13-04 R3