Registered aircraft · 493

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:98-08-19') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-08-19') 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:98-08-19')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-08-19')
  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:98-08-19')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-08-19')
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.

N1010FHangar 10 Aviation LLC · Durant, OKS/N 1403-145 N1021N1021 Inc · Wilmington, DEBuilt 1972 · S/N 12016 N102RRMoyer Aviation Ll C · Katy, TXS/N 1477-5 N103SLAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N 11735 N104DTDavis Brenda Kruszewski · Middleton, IDBuilt 1981 · S/N 96010 N106FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1978 · S/N 3305 N107VCLopez Hidaldo Vicente · San Juan, PRBuilt 1960 · S/N 893-1 N108SAFlying A Flight Service LLC · Safford, AZBuilt 1977 · S/N 11416 N10RTBarbers Point Flight School LLC · Kapolei, HIS/N 285 N110WBFerrin Aviation LLC · Rome, GABuilt 1962 · S/N 500B-1203-98 N112AANestor Richard · Portsmouth, NHBuilt 1964 · S/N 1436-153 N112EESpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11330 N114MNSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 1553-107 N1151ZRenfro Michael W · Bethel, AKS/N 1524-186 N1165ZRegistration Pending · Las Cruces, NMRegistration pendingBuilt 1965 · S/N 1555-198 N1169Downes Pamela · Chino Hills, CABuilt 1956 · S/N 390 N1176ZAirborne Support Inc · Bourg, LABuilt 1965 · S/N 500-B-1549-196 N1187DCordero Miguel · Hollywood, FLS/N 680-626-252 N118PWCentral Airlines Inc · Fairway, KSBuilt 1964 · S/N 1460-163 N11LWilkins Daryl J · Linden, CABuilt 1953 · S/N 520-109 N1203NBracy Rodney E · Middleville, MIBuilt 1972 · S/N 12046 N121JWGlobal Jet LLC · Missoula, MTBuilt 1975 · S/N 11299 N121SPFl280 LLC · Deland, FLBuilt 1960 · S/N 500B-984-25 N123HTReyes Carlos E · San Juan, PRS/N 3300 N124JPCommemorative Air Force · Dallas, TXBuilt 1956 · S/N 312 N125MMFox Tango Tango Inc · Houston, TXBuilt 1979 · S/N 11605 N127HJPonderosa Aviation LLC · Safford, AZBuilt 1978 · S/N 11467 N127KHCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1027-38 N129MBYellowfin Air Services LLC · Wilmington, DEBuilt 1971 · S/N 3108 N12VAAirborne Research LLC · Fort Pierce, FLS/N 96062 N131JTCentral Airlines Inc · Overland Park, KSBuilt 1964 · S/N 1468-166 N138KSouth Bay Aviation Inc · Torrance, CAS/N 720-621-2 N13RABarney Adam Joseph · Altamonte Springs, FLBuilt 1975 · S/N 11235 N1420VCommander Trust LLC · Fort Lauderdale, FLBuilt 1979 · S/N 11524 N147FBrown Helicopter Inc · Pensacola, FLBuilt 1964 · S/N 1432-152 N14FFK & L Agri Farms Inc · Adams, NEBuilt 1961 · S/N 560F-1107-31 N151LTBoss Dog LLC · Sheridan, WYBuilt 1963 · S/N 1316-125 N1525Aviaton Business Corporation · Saint Louis, MOBuilt 1973 · S/N 12022 N152KWestern Capital Partners LLC · Wilmington, DEBuilt 1962 · S/N 500A-1258-82 N159KIsland Hopper Air LLC · Ponte Vedra Beach, FLBuilt 1959 · S/N 751 N15CDCommander N15cd LLC · Miami, FLS/N 11177 N15SFKolob Canyons Air Services Inc · Wilmington, DEBuilt 1979 · S/N 11528 N160XMalolo LLC · San Luis Obispo, CAS/N 500B-1300-115 N161BLAirborne Holdings Inc · Midlothian, TXBuilt 1965 · S/N 1551-197 N162ALNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11231 N165KMowbray Aviation Inc · Reno, NVBuilt 1963 · S/N 680F-1252-126 N167RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 11437 N16JCRl Equipment And Services LLC · Monument, COBuilt 1972 · S/N 3128 N171ATAloft Aviation Services LLC · Spartanburg, SCBuilt 1966 · S/N 1616-49 N171ZCaribbean Flyers LLC · New York, NYBuilt 1964 · S/N 1450-159

Back to AD 98-08-19