Registered aircraft · 1,770

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:2018-03-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:2018-03-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:2018-03-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:2018-03-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:2018-03-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:2018-03-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.

N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097 N100AJN8006j LLC · Shiloh, ILBuilt 1972 · S/N 421B0322 N100AZNnww Holdings LLC · San Angelo, TXS/N 421C1051 N100CCSeneca Tank · Des Moines, IABuilt 1982 · S/N 425-0170 N100CXCs Leasing LLC · Rockville, MDBuilt 1980 · S/N 414A0623 N100JDMark Aviation LLC · Kingsport, TNBuilt 1981 · S/N 414A0669 N100JLBytelogics Inc · New York, NYS/N 421-0008 N100LCozumel Leasing LLC · Wilmington, DEBuilt 1977 · S/N 421C0313 N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429 N101CANorton Energy Drilling LLC · Lubbock, TXS/N 425-0142 N101HLPapoose Air II LLC · Wilmington, DEBuilt 1981 · S/N 425-0056 N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130 N101PSJtech Solutions Inc · San Ramon, CABuilt 1982 · S/N 4250108 N101TAHatch Hyrum G · Gilbert, AZBuilt 1977 · S/N 421C0331 N1027DRobins Jack S · Saint Charles, IDBuilt 1968 · S/N 421-0196 N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135 N103JGRam Aero Development Inc · Waco, TXBuilt 1979 · S/N 414A0264 N104WMHamilton Aviation LLC · Morehead, KYBuilt 1975 · S/N 421B0964 N105FC4j Air LLC · Newark, DEBuilt 1981 · S/N 425-0094 N105KAGillespie Todd · Trenton, SCS/N 401-0238 N106CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1020 N108LVVandermolen Louis A Md · Laguna Beach, CAS/N 414A0841 N10FFValiair Lc Co Trustee · Casper, WYBuilt 1976 · S/N 421C0082 N10FZAirflair Inc · Maurice, IABuilt 1981 · S/N 425-0117 N110DHYingling Consultation LLC · Wilmington, DES/N 421B0137 N110VEHorizon Group Inc Trustee · Boca Raton, FLBuilt 1977 · S/N 414A-0017 N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368 N111KULot-A-Go Six LLC · Polson, MTBuilt 1985 · S/N 425-0226 N111TFPacific Aviation Aircraft Management Inc · Ontario, ORBuilt 1974 · S/N 421B0660 N111TLNdk Global Holdings Corp · Dover, DEBuilt 1974 · S/N 421B0645 N112ALPassport Auto & Aviation Inc · Richmond, VABuilt 1979 · S/N 421C0697 N112MJTm Aero LLC · Riverview, FLS/N 421C0907 N113GLBushwacker Aviation LLC · Benton, ARBuilt 1978 · S/N 414A0072 N113MPBan Air LLC · Boerne, TXBuilt 1982 · S/N 421C1235 N1141XChancellor Aviation LLC · Billings, MTBuilt 1978 · S/N 414A0215 N114HLRegistered aircraftBuilt 1981 · S/N 425-0110 N114HVAerowerks LLC · Georgetown, TXBuilt 1973 · S/N 421B0371 N114MHVlavic Aviation LLC · Hallandale Beach, FLBuilt 1979 · S/N 414A0458 N116JJProgress Aviation LLC · Ellicott City, MDBuilt 1984 · S/N 421C1404 N116PAJht Aircraft LLC · Wilmington, DEBuilt 1978 · S/N 414A0021 N1188G207rs LLC · Santa Feon, NMBuilt 1984 · S/N 425-0202 N119PARicciardi Brian P · Hyannis, MAS/N 402B0610 N119SKKing Air 3au LLC · Wichita, KSS/N 414A0660 N11BNAlpha 414a LLC · New Smyrna Beach, FLBuilt 1979 · S/N 414A0311 N1203GWestern Pilot Service Inc · Phoenix, AZBuilt 1975 · S/N 414-0649 N1206KOnuzo Chika N · Fayetteville, GAS/N 421C1804 N1206NCapital Group Inc · Garden City, IDBuilt 1985 · S/N 421C1805 N120PCHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0079 N1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652 N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653

Back to AD 2018-03-03 R1