Skip to content

Registered aircraft · 72,010

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

N5501WTailwinds Aviation LLC · Kokomo, INBuilt 1962 · S/N 28-587 N5501YBas Part Sales LLC · Greeley, COS/N 27005C N55021Robertson Alan L · Hastings, NEBuilt 1973 · S/N 28-7305294 N55023Charron William H · Burwell, NEBuilt 1973 · S/N 28R-7335168 N55028First Alarm Aviation LLC · Fosters, ALBuilt 1973 · S/N 28-7305295 N55029Chandler William John · North Palm Beach, FLBuilt 1973 · S/N 28-7305296 N5502AAero Enterprises LLC · Orange, VABuilt 1978 · S/N 408-78 N5502HSky View LLC · De Smet, SDS/N 1035-78 N5502MRegistered aircraftBuilt 1978 · S/N 275-78 N5502PBeans David W · Sharpsburg, MDBuilt 1958 · S/N 24-564 N5502QAcademy Computer Services Inc · Stoneham, MABuilt 1965 · S/N 604 N5502WWest Kentucky Wings And Toons LLC · Benton, KYBuilt 1962 · S/N 28-589 N5502YCreative Strategies Inc · Grayson, KYBuilt 1964 · S/N 27-2596 N55030Reiner John G · Wakefield, MIBuilt 1973 · S/N 28R-7335171 N55031Monaghan Management Corp · Greenwood Village, COBuilt 1973 · S/N 28-7310108 N55032Jacks Dean E · Madison, INBuilt 1973 · S/N 28-7310109 N55033Mcneill James R · Wichita, KSBuilt 2006 · S/N 47002T N55034Osceola Aerosport LLC · Osceola, WIBuilt 1978 · S/N 420-78 N5503AKey Dallas T · Hoover, ALBuilt 1978 · S/N 411-78 N5503CMccreary William J · Glendale, AZBuilt 1978 · S/N 412-78 N5503FN5503f Aircraft Holdings LLC · Orangeburg, SCBuilt 1968 · S/N 28-24842 N5503HCp Aviation Inc · Santa Paula, CABuilt 1978 · S/N 413-78 N5503JFalterman Patrick J · Cleveland, TXBuilt 1978 · S/N 414-78 N5503LAnderson Firearms LLC · Montgomery, TXBuilt 1999 · S/N 25040C N5503PCore Tech Services And Supply LLC · Odessa, FLBuilt 1958 · S/N 24-565 N5503QPrecious Metal Aviation LLC · Menomonee Falls, WIBuilt 1965 · S/N 2940 N5503UFuller Christopher Jason · Destin, FLBuilt 1969 · S/N 28-26211 N5503YBundt Benjamin L · Montebello, CABuilt 1978 · S/N 418-78 N55041Napier Clarence M · Mount Juliet, TNBuilt 1973 · S/N 28-7305297 N55042Rohrbaugh Mark A · Lenexa, KSBuilt 1973 · S/N 28-7305298 N55044Yale Aviation Inc · New Haven, CTBuilt 1973 · S/N 28-7305299 N55049Spanier Sherri Kay · Belleview, FLBuilt 1973 · S/N 28-7310111 N5504FWieselquist Kermit L · Westford, MABuilt 1968 · S/N 28-24843 N5504KWhite Traci Michelle · Manasquan, NJBuilt 1978 · S/N 1047-78 N5504PLanghorst Richard C · Waltham, MEBuilt 1958 · S/N 24-567 N5504QDoll Electric Co Inc · Murphys, CABuilt 1965 · S/N 605 N5504SBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1978 · S/N 277-78 N5504WTaylor Deric C · Seguin, TXBuilt 1962 · S/N 28-591 N5504YTarkington John W · Almyra, ARBuilt 1978 · S/N 423-78 N55050Newman Jeffrey M · Pauline, SCBuilt 1973 · S/N 32-7340097 N55051Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 34-7350166 N55055Martan LLC · Kansas City, MOBuilt 1973 · S/N 28-7305301 N55057Smooth Air LLC · Churubusco, INBuilt 1973 · S/N 28-7305302 N55058Eggensberger Edmund G · Simpsonville, SCS/N 28R-7335174 N5505FSerafinowicz Ronald P · Gilbert, AZBuilt 1968 · S/N 28-24844 N5505HKupferschmidt W Alan Trustee · Lake Elmo, MNBuilt 1978 · S/N 1038-78 N5505LRegistration Pending · Saint Johns, FLRegistration pendingBuilt 1974 · S/N AA5-0505 N5505MCapozzi Eugene L · Kalispell, MTBuilt 1978 · S/N 424-78 N5505PLandmann Ryan J · Fort Walton Beach, FLS/N 24-568 N5505QReynolds C J · Cornelius, NCBuilt 1965 · S/N 2941

Back to AD 87-10-06 R1