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.

N6292ELucci Giacinto A Jr · Nashville, MIS/N 46392 N6292RHynes Kevin P · Wichita Falls, TXBuilt 1979 · S/N 172RG0152 N62938Two Guys Aviation LLC · Idaho Falls, IDBuilt 1981 · S/N 17275361 N6293EWatkins Jerry G · Portland, ORBuilt 1959 · S/N 46393 N6293GMindy Limited LLC · Muscatine, IABuilt 1979 · S/N 17273588 N62946Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275365 N6294EFlightpath Leasing LLC · Tallahassee, FLS/N 46394 N6294RMitrenko Alexander V · Selinsgrove, PABuilt 1979 · S/N 172RG0154 N62953Dodge Inc · Wilmington, DEBuilt 1981 · S/N 17275367 N6295DCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272700 N6295EBuffo Perry J · Albion, NJBuilt 1959 · S/N 46395 N62960Fossen Kenneth J · Omaha, NEBuilt 1981 · S/N 17275368 N6296EKlad-Air LLC · Catlett, VABuilt 1959 · S/N 46396 N6296FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273185 N6299DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272704 N6299ECarpenter Daniel R · Jefferson City, MOBuilt 1959 · S/N 46399 N629AHSuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9301 N629BCVolar V LLC · Edmond, OKBuilt 2013 · S/N 172S11277 N629EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2021 · S/N 172S12750 N629MMMcgraw Michael T · Gainesville, GABuilt 1973 · S/N 17262164 N62AWDirty Side Down Aviation LLC · Georgetown, TXBuilt 1998 · S/N 17280504 N62GKAugusta Flying Club Inc · Martinez, GABuilt 1978 · S/N 17271667 N62LULouisville Aircraft Leasing LLC · Louisville, KYBuilt 1998 · S/N 17280590 N62PBAlabama Fly Boys LLC · Cropwell, ALBuilt 1962 · S/N 17249273 N62SMBell Charles S · Fort Payne, ALBuilt 1973 · S/N 17261862 N62WPCarver Joseph · Bryson City, NCBuilt 1962 · S/N 17249440 N63014Taylor Daniel S · The Woodlands, TXBuilt 1981 · S/N 17275374 N63017Adams Aviation Services Inc Trustee · Wilmington, DEBuilt 1981 · S/N 17275377 N63019Althaver David B · Kearny, NJBuilt 1981 · S/N 17275379 N6301DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272706 N6301EJc Air Academy Inc · Stockton, CAS/N 17272004 N6302FForrest Steven L · Wrangell, AKBuilt 1967 · S/N 17255486 N6306FBaymax Aviation LLC · Ronkonkoma, NYS/N 17273186 N6307JMiloud Chadd · Fort Worth, TXBuilt 1980 · S/N 17273860 N6308JKatuzienski Joseph C · Yorktown, VABuilt 1980 · S/N 17273861 N6308RIngalls Randy · Alexandria, LABuilt 1979 · S/N 172RG0159 N6309VHamilton Paul L · Arlington, VABuilt 1980 · S/N 172RG0617 N630HRMiga Holdings LLC · Flower Mound, TXBuilt 2006 · S/N 172S10205 N630TCN630tc LLC · Nashville, TNBuilt 1976 · S/N 17267047 N63101Gill Michael J · Marshfield, MABuilt 1981 · S/N 17275391 N6310EMinor Mark · Central Point, ORBuilt 1959 · S/N 46410 N63113High Road Time LLC · West Palm Beach, FLS/N 17275392 N6313EGottshall Curt E · Monroe, WABuilt 1959 · S/N 46413 N6313FTeens In Flight Inc · Palm Coast, FLBuilt 1979 · S/N 17273188 N6314EWeber Tom L · Douglas, WYBuilt 1959 · S/N 46414 N6316DRuiz Edinson · Bakersfield, CABuilt 1979 · S/N 17272714 N63174Evans James II · Seattle, WAS/N 17275399 N63177Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10778 N6317DJkg LLC · Murfreesboro, TNBuilt 1979 · S/N 17272715 N6317GChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10777

Back to AD 90-06-03 R1