AD 98-21-21 R1
Registered aircraft · 85,612
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.
N311SRed Rock Construction Inc · Hydro, OKN311SFBaymag Aviation LLC · Mountain Home, ARN311SKDoyle Thomas Michael · New City, NYN311WCIndy Aviation LLC · Dover, DEN311XStevens Adam · Dacono, CON311ZRegistration Pending · Rockford, ILRegistration pendingN3120BRustad Scott K · Minot, NDN3120ETandberg Kjell · Beverly Hills, FLN3120FLengyel Roger · Santa Fe, NMN3120MCowtown Aviation LLC · Aledo, TXN3120QLinda In The Sky LLC · Webster, MNN3120RBulang Investments LLC · Newbury, NHN3120TMcbride Matthew T · Eagle River, WIN3120WWiese Chuck F · Portland, ORN3121CUnkefer Edward Lowell · Waynesboro, VAN3121DFrey Jerry P · Fallon, NVN3121FLily Chris H · Ocala, FLN3121VCochise Community College · Douglas, AZN3121WAlpha Dog Aviation LLC · Marco Island, FLN31222Dc Air LLC · Lebanon, MON3122AJohns William D · Lodi, CAN3122EKantec Inc · Cary, NCN3122LE C G Aviation Inc · Orange, CAN3122MMiller-Jackson Co Inc · Oklahoma City, OKN3122RMarrow Henry G · Southern Pines, NCN3122STecumseh Skydiving School LLC · Tecumseh, MIN3122UTravel Aviation Inc · Vineyard Haven, MAN3122YJti Management LLC · Colfax, WAN3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeN3123EKanase Padmaneel B · Amarillo, TXN3123QDarkhorse Six Inc · Boerne, TXN3123RHs Aviation Holdings LLC · Eagle, IDN3123SGabin LLC · Tulsa, OKN3123WSullivan Dan · Kingwood, TXN3123YAbecca Corporation · Jackson, MIN31241Hotel Charlie Aero LLC · Marshville, NCN3124AWolstenholme Robert · Line Lexington, PAN3124BUsda Aphis Ws Atoc · Cedar City, UTN3124DBurch David C · Flushing, MIN3124FTrue Aviators LLC · Kiowa, KSN3124RMidland Liberty LLC · Midland, MIN3124WBaron 24w LLC · Outing, MNN3125DDavis Ronald L Jr · Soldotna, AKN3125FHall Aircraft LLC · Kenai, AKN3125GEastern Kentucky University · Richmond, KYN3125LOxley Lake Solutions LLC · Lawton, MIN3125QSunrise Aviation Llp · Gig Harbor, WAN3125WRowe Benjamin Stratton · Nome, AKN3125YOberdoerster Timothy L · Concord Township, OHN3126ALutz Adam R · Kodiak, AK
Back to AD 98-21-21 R1