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.

N477RSSundbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0477 N4795GAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 414-0949 N4798CKjv Aviation Inc · Brentwood, CAS/N 414-0012 N47AJHigh Plains Anesthesia Pc · Cheyenne, WYBuilt 1983 · S/N 425-0182 N47JDQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 421C0805 N47MDBrambles Inc · Bakersfield, CABuilt 1977 · S/N 414-0945 N4837ALongleaf Wing Ventures LLC · Birmingham, ALBuilt 1978 · S/N 414A0101 N483JFKg Aviation LLC · Huntington, WVBuilt 1974 · S/N 414-0537 N483MMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1977 · S/N 421C0314 N484SWElsass Aviation LLC · Fayetteville, ARBuilt 1980 · S/N 414A0497 N485CBBlue Pathways LLC · Statesville, NCS/N 421C0466 N485DSEncinal Aviation LLC · Springfield, MOBuilt 1978 · S/N 421C0459 N488DMAircraft One Ltd · Grand Rapids, MIS/N 421C-0485 N488KRedcell Air Inc · Miami, FLBuilt 1976 · S/N 421C0078 N488SSale Reported · Friday Harbor, WASale reported, pending cancellationS/N 4140529 N488SJDeans Casing Service Inc · Holdenville, OKFirst renewal noticeBuilt 1977 · S/N 414-0959 N48AMGwc Air LLC · Madison, ALBuilt 1980 · S/N 414A0609 N48BPRossman Richard J DBA · Glenview, ILBuilt 1975 · S/N 421B0957 N48CPDouglas Aviation Ltd · South Barrington, ILS/N 421C0902 N490KMRasf414 LLC · Hallandale Beach, FLS/N 414-0399 N493JHBrooklyn LLC · Parker, COS/N 421C0860 N494BCHyannis Air Service Inc · Hyannis, MAS/N 402C0308 N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487 N499ATN633at LLC · Punta Gorda, FLS/N 414A0306 N499CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1006 N499WWLakes Air LLC · Fargo, NDBuilt 1966 · S/N 411-0161 N49ARMoore Thomas A · Kennewick, WAS/N 421B0563 N49GM3-J Air LLC · Miami, OKBuilt 1982 · S/N 425-0165 N4ADValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 421B0467 N4AFN4af LLC · Conroe, TXBuilt 1968 · S/N 421-0142 N4MUBlusky Properties & Investments LLC · Cameron, MOBuilt 1970 · S/N 421B0054 N4MZBank Of Utah Trustee · Salt Lake City, UTS/N 421C0829 N4VHFoster Chad H Jr · Uvalde, TXBuilt 1977 · S/N 421C0435 N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318 N500TJAirbyars LLC · Spartanburg, SCBuilt 1974 · S/N 421B0585 N501CLSalt Aerial Aviation LLC · Hamel, MNS/N 414A0339 N502ATAir Note LLC · Delray Beach, FLBuilt 1973 · S/N 421B0547 N502JJMrch Airways Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1970 · S/N 414-0061 N502SAZambrano Homero Ramones · Bulverde, TXBuilt 1978 · S/N 421C0520 N503NAClover Park Technical College · Lakewood, WAS/N 402B-0313 N505CNLes Amis Air LLC · Dorado, PRBuilt 1978 · S/N 414A0201 N505LTLaufer Air Inc · Hartford, WIBuilt 1978 · S/N 421C0617 N505RWCor Group LLC · Arlington, WAS/N 421B0268 N509RSHalf Shell Aviation LLC · Highlands Ranch, COBuilt 1978 · S/N 414A0060 N50CBHughes Eugene F Jr · Butte, MTBuilt 1979 · S/N 414A0228 N50DLSand Castle Management LLC · Wichita, KSBuilt 1973 · S/N 421B0526 N50LWildcat Aeroplanes LLC · Sedalia, COBuilt 1977 · S/N 421C0431 N50MAGoodhue David H · Vancouver, WABuilt 1979 · S/N 414A0434 N50ZPPalen Mark T Trustee · Cleveland, TNBuilt 1975 · S/N 421C0022 N510NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C1001

Back to AD 2018-03-03 R1