Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N3823RElectra-Vision Advertising Corp · Claremont, CABuilt 1966 · S/N 17255323 N3823SBurbank David E · Oak Harbor, WABuilt 1963 · S/N 17251023 N3824LNewhart Manfred A · Boulder, COBuilt 1965 · S/N 17253993 N3824SPhelps Aero Co LLC · Salem, ORBuilt 1963 · S/N 17251024 N3825QFischer Roger G · Torrance, CABuilt 1971 · S/N 17259925 N3825RHoogstra Jay D · Sheboygan Falls, WIBuilt 1966 · S/N 17255325 N3826SLamal Thomas K · Fairbanks, AKBuilt 1963 · S/N 17251026 N3827RSeaplanes R Fun Inc · Wilmington, DEBuilt 1966 · S/N 17255327 N3829LMustang Aviation LLC · Waterville, MEBuilt 1965 · S/N 17253998 N3829QMiller Randall J · Arlington, WABuilt 1971 · S/N 17259929 N3829RGibbons Warren · Toledo, OHS/N 17255329 N3829SHagler Bennett J · San Carlos, CABuilt 1963 · S/N 17251029 N382DFDream Flight LLC · Westminster, MDBuilt 1976 · S/N 17268233 N382JNSilver Sky Air LLC · Fresno, CABuilt 1973 · S/N 17262794 N3830QAero Place Flyers Inc · Urbana, ILBuilt 1971 · S/N 17259930 N3830RPace Michael C · Atlanta, GABuilt 1966 · S/N 17255330 N3830SWin Win Aviation Inc · Wake Forest, NCBuilt 1963 · S/N 17251030 N3832LArnold Jonah Jr · Milledgeville, GABuilt 1966 · S/N 17254001 N3832RDemopoulos Chris · Dyer, INBuilt 1966 · S/N 17255332 N3833QDowning Robert · Talent, ORBuilt 1971 · S/N 17259933 N3833SBoehm Shannon Lynn · Mandan, NDBuilt 1963 · S/N 17251033 N3834LZoltak Aviation LLC · Perry, GABuilt 1965 · S/N 17254003 N3835SMorgan Leon O · Eagle River, AKS/N 17251035 N3836RWard David E · Quilcene, WABuilt 1966 · S/N 17255336 N3836SDavis Michael W · Medicine Lodge, KSBuilt 1963 · S/N 17251036 N3837LMountain Town Flying LLC · Hammondsport, NYBuilt 1965 · S/N 17254006 N3837QBaja Guided Tripps LLC · Grand Lake Stream, MEBuilt 1971 · S/N 17259937 N3838LBerry Charles J · Shreveport, LABuilt 1965 · S/N 17254007 N3838RAviation Rentals LLC · Oakman, GABuilt 1966 · S/N 17255338 N383BHAero Aircraft 13 LLC · Jacksonville, FLBuilt 1974 · S/N 17264151 N383DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12648 N383DFDream Flight LLC · Westminster, MDBuilt 1977 · S/N 17269914 N383MEParlu Ventures LLC · Eagles Mere, PABuilt 2000 · S/N 172S8567 N383SPKv Helicopters LLC · Lititz, PABuilt 1999 · S/N 172S8279 N383TCSpengler Raymond Francis Jr · Longview, TXBuilt 2003 · S/N 172S9383 N3840LMikha Marvin · Nampa, IDS/N 17254009 N3841LFisher John J · Middlefield, OHBuilt 1965 · S/N 17254010 N3842LKraupie Del Ray · Bridgeport, NES/N 17254011 N3842SKrahn Nicholas D · Oak Creek, WIBuilt 1963 · S/N 17251042 N3842VN3842v LLC · Wainscott, NYBuilt 1973 · S/N 17262158 N3843RHarbor View Air LLC · Kalispell, MTBuilt 1966 · S/N 17255343 N3844QSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 17259944 N3845QMacon Flying Club Inc · Macon, MOBuilt 1971 · S/N 17259945 N3845RDelaney Patrick James · Marion, TXS/N 17255341 N3846LElicker Sheldon L · Auburn, CABuilt 1966 · S/N 17254015 N3846RSampson Corey · Newnan, GABuilt 1966 · S/N 17255346 N3848LHarrod Group Inc · Ellaville, GABuilt 1966 · S/N 17254017 N3848QWestwind Flyers LLC · Friday Harbor, WABuilt 1971 · S/N 17259948 N3848RGunter Jeffrey W · Demorest, GAS/N 17255348 N3849QSmetana Louis V III · Blair, NEBuilt 1971 · S/N 17259949

Back to AD 90-06-03 R1