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.

N413GKKgc Holdings Ltd · Newark, TXBuilt 1973 · S/N D-9450 N413KGEagle Mountain International Church Inc · Newark, TXBuilt 1976 · S/N TE-1076 N413KJHuber Jeffrey C · Sidney, OHBuilt 1980 · S/N D-10307 N413MBrookway Investments LLC · Brookhaven, MSBuilt 1977 · S/N E1151 N413SLMilestone Plane LLC · Wilmington, DEBuilt 1988 · S/N CE-1289 N413WGHavana Farms Equipment · Gilliam, LABuilt 1976 · S/N E-804 N4143SFrederickson Mark T · Cameron Park, CABuilt 1975 · S/N D-9743 N4144SJlh Ent LLC · Wilmington, DEBuilt 1975 · S/N E-655 N4146APinpoint Investment Capital Inc · Healdsburg, CABuilt 1999 · S/N EA-646 N4147SDrew Danny Paul · Broken Arrow, OKBuilt 1975 · S/N CE-565 N4149SDelgado Dimitri Antonio · Tampa, FLBuilt 1975 · S/N D-9745 N414ASRobertson Julianne · Los Osos, CABuilt 1991 · S/N EA-523 N414SWRmi Air LLC · Ocilla, GABuilt 1977 · S/N TH-797 N4150SDirks Ricky B · Derby, KSBuilt 1975 · S/N CE-566 N4151SMidland Avionics LLC · Louisville, KYS/N D-9746 N4154SWilanco Inc · Berkeley, CABuilt 1975 · S/N D-9751 N4155FOmg Air LLC · Redwood City, CABuilt 1992 · S/N E-2721 N4156SMatt Cartwright · Austin, TXBuilt 1975 · S/N E-660 N4157SGarretson Chad · Mesa, AZBuilt 1975 · S/N CE-564 N415GB415gb LLC · Encinitas, CABuilt 2000 · S/N E-3363 N415JLOlson Douglas W · Yarmouth Port, MABuilt 1981 · S/N E-1801 N415LWWest Thomas Lee · Payson, AZBuilt 1984 · S/N TH-1417 N4162SFiresheets William R · Zwolle, LABuilt 1975 · S/N CE-568 N4163ASalida Aviation Partnership Group · Moffat, COBuilt 1970 · S/N D-9121 N4163SLarson Family Farms LLC · Haxtun, COBuilt 1975 · S/N E-664 N4164SFabien Turpaud Corp · Lewes, DEBuilt 1975 · S/N D-9753 N4165S5100 Departure LLC · Beaufort, NCBuilt 1975 · S/N TE-1049 N4166SBurgess Stephan H · Nags Head, NCBuilt 1975 · S/N CE-569 N4169SHp Aero Vantage LLC · Sand Springs, OKBuilt 1975 · S/N CE-570 N416BRSeiler Valerie K Trustee · Hoffman Estates, ILBuilt 1987 · S/N CE-1187 N416DMcginnis Aviation LLC · Kentwood, MIBuilt 1974 · S/N TH-500 N416JSC Randy Landis Dds Inc · Oroville, CABuilt 1973 · S/N TH-416 N416RWRoyal Wings Aviation Inc · Shreveport, LABuilt 1984 · S/N E-2133 N4171SSteffey Kevan J · Bullhead City, AZFirst renewal noticeBuilt 1975 · S/N E-667 N4172SWharton Roofing Services LLC · Gulf Breeze, FLBuilt 1975 · S/N CE-571 N4175SBauman Loren A · Lewisville, NCS/N D-9756 N4177SMiles Insurance Inc · Inverness, ILBuilt 1975 · S/N D-9757 N4178SGlad Aviation LLC · Gilford, NHBuilt 1975 · S/N TH-652 N417KKinsley Joshua P Trustee · Carlsbad, CABuilt 1999 · S/N E-3269 N417WCMpi Warehouse Specialty Company Inc · Casper, WYBuilt 1985 · S/N EA 451 N4180SPalomino Princess Express LLC · Helena, MTS/N D-9755 N4181SArizona Type Ratings LLC · Sedona, AZBuilt 1975 · S/N E-672 N4182SSassine Alain · Estero, FLS/N E-668 N4185SJetset Aviation LLC · Helena, ALBuilt 1975 · S/N CE-575 N4187SJ&S Aviation Services LLC · Hastings, NES/N D-9765 N4188SMajor Air LLC · Charleston, SCBuilt 1975 · S/N TH-620 N4189SHigh Planes Holdings LLC · Lexington, NEBuilt 1975 · S/N E-676 N418RWPower Aero Inc · Scituate, RIBuilt 1978 · S/N TH-917 N4192ARocky Mountain Aviation Inc · Wilmington, DEBuilt 1970 · S/N D-9128 N4192SStecklein Aviation LLC · Colleyville, TXBuilt 1975 · S/N D-9766

Back to AD 87-18-06 R1