AD 98-01-01
Registered aircraft · 1,289
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-01-01')
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-01-01')
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-01-01') 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-01-01') 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.
N12EEArizona Cloudbusters Inc · Mesa, AZN130MEPetersens Marine Services Corp · Ridge, NYN132MEPena Jairo · Catharpin, VAN132PFAbove And Beyond Aviation LLC · Austin, TXN132VUPerformance Aircraft Sales Inc · Lincoln, NEN133VUPerformance Aircraft Sales Inc · Lincoln, NEN134DBBlue Skies27 LLC · Los Angeles, CAN134VUPerformance Aircraft Sales Inc · Lincoln, NEN135VUPerformance Aircraft Sales Inc · Lincoln, NEN136VUPerformance Aircraft Sales Inc · Lincoln, NEN137MACivil Aviation Inc · Waukesha, WIN137VUPerformance Aircraft Sales Inc · Lincoln, NEN13986Euro 2000 Inc · Merritt Island, FLN139RABeach Cruisers LLC · Ormond Beach, FLN146NEAngle Mark W · Lake Orion, MIN146WHAmick Ralph O · Hatteras, NCN148SMSarasota Westwind Flyers Inc · Sarasota, FLN149MEMccrary Mike M · Fairhope, ALN149UDW Air LLC · Chicago, ILN151BSEvans Linda J · North Wales, PAN151MELoweth William A · Noank, CTN152MEChamp Jerry D · Belton, SCN157RDBoman & Kemp Lc · Ogden, UTN157SMHumphreys James F · Charleston, WVN157ZZRegistered aircraftN1589DN1589d LLC · Stuart, FLN158JRCollins Stephen Neil · Clancy, MTN158RAJohneco Inc · Beachwood, OHN1590WCc Aviation Inc · Tracy, CAN159DRPiedmont Flight Inc · Winston Salem, NCN159FSEastern Kentrucky University · Richmond, KYN162CSFrielingsdorf Tim Richard · Manvel, TXN162TCDrummond E Garrison · Parksley, VAN163JBBender W Jeffrey · Ocala, FLN164SJFriedman Matthew · Herndon, VAN165YPSpanaflight LLC · Puyallup, WAN167SJAbove And Beyond Aviation LLC · Austin, TXN167UDLima 001 LLC · Muscatine, IAN168DSVertx Fleet Holdings LLC · San Diego, CAN169PXXing Kong Aviation Service LLC · Atwater, CAN171STDkg Motorized Conveyances Inc · Beaverton, ORN17274University Of Alaska Anchorage · Anchorage, AKN17297Barrier William · Pensacola, FLN172BFLewis University · Romeoville, ILN172DRCunningham Darius L · Sterling, VAN172EFNorth Shore Aero Club Inc · Beverly, MAN172FNSkyhawk 172 LLC · Eugene, ORN172GHNebel & Son Aircraft Leasing Inc · Jacksonville, FLN172HPSpinnaker Aviation LLC · Conroe, TXN172JEBachman Aviation Inc · Winter Haven, FL
Back to AD 98-01-01