AD 98-21-21 R1
Registered aircraft · 85,620
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
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-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.
N161ABSafford Aviation Service Inc · Coolidge, AZN161APT3 Aerosports LLC · Vian, OKFirst renewal noticeN161AWAir Ward Inc · Columbia, CAN161BGWilson James R · Midlothian, VAN161DERegistered aircraftN161EWalsh David E · North Platte, NEN161FKaminski Michael Jr · Ford City, PAN161KCCk Aviation LLC · Melbourne, ARN161KMParis Air Inc · Vero Beach, FLN161MABarnes Gordon R · Manalapan, NJN161MBKerf 25 Corp · Wilmington, DEN161MPJb Aviation LLC · Newark, OHN161MRVictor Aircraft Co · Wilmington, DEN161PRegistered aircraftN161PTPilot Training Center LLC · Miami, FLN161RBower Fredrick S · Watervliet, MIN161REVornholt David · New Richmond, OHN161RPCrucial LLC · Kalispell, MTN161SMMorcom Aviation Services Inc DBA · Everett, WAN161SWLober Cameron K · Matthews, NCN161TFAirmart Inc · Lexington, KYN161TRRambo Timothy B · Nampa, IDN161TSDoege Jackson B · Dallas, TXN161VPConservation Aviation LLC · Washington, DCN161WCater Christopher B · Lowell, MIN1621DPease Rex A · Grand Haven, MIN1621FDimtroff John P · Issaquah, WAN1621WColeman Alan · Tyler, TXN1622CPutnal Aviation LLC · Ambrose, GAN1622FN1622f LLC · Grand Prairie, TXN1622PBaker Kenneth C · Brenham, TXN1622WN83993 LLC · Cherry Hill, NJExpired dealerN1623CCarlson Thomas G · Anchorage, AKN1623FVilvens Justin T · Granville, OHN1623MMountain Ranch Air Inc · Sioux Falls, SDN16244Oakland William S · New Port Richey, FLN1624FPruitt Leonard E · The Colony, TXN1624HSynergy Aviation LLC · Forest Lake, MNN1624WHill Travis · Smithville, TXN1624YFallbrook Fly Girl LLC · Lakeside, ORN162505b Aviation LLC · Duncan, OKN16252Robbins Warren N · Chandler, AZN16253Quincy Aircraft LLC · Quincy, ILN16257Chauvet Nicolas · North Kingstown, RIN1625DHatcher Aviation LLC · Little Rock, ARN1625JCain Philip K · Escondido, CAN1625UFly2k LLC · San Jose, CAN1625WGunter Professional Pilot Services LLC · Wichita Falls, TXN1625YBoyd Jeffrey J · Justin, TXN16269Kelley John Charles · Hot Springs Ntl, AR
Back to AD 98-21-21 R1