AD 98-11-01 R2
Registered aircraft · 420
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-11-01-R2')
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-11-01-R2')
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-11-01-R2') 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-11-01-R2') 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.
N212PKOc Aviation LLC · Victoria, TXN216KCBlack Kettle Inn LLC · Cabool, MON217EBRapids Camp Lodge Inc · King Salmon, AKN219PCRyan Air Inc · Anchorage, AKN21AUBoeing Co · Renton, WAN221PCRegistered aircraftN2222CDodson International Parts Inc · Rantoul, KSN222CMBriar Lakes Productions Inc · Palestine, TXN224TWBedford Partners LLC · Oxford, CTN226AALegacy Air 03 LLC · Grand Forks, NDN227MFMeragals LLC · Evergreen, CON228JDValiair Limited Company Trustee · Casper, WYN22LPAir Pilatus 22lp LLC · Spanish Fork, UTN230UHU-Haul Co Of Oregon · Phoenix, AZN231BWN231bw LLC · Hayden, IDN234RGCsc Delaware Trust Co Trustee · Wilmington, DEN238VMGuardian Flight LLC · Lewisville, TXN241HClassic Medical Inc · Woods Cross, UTN242JHDelta Properties Llp · Nogales, AZN242MA242ma LLC · Chicago, ILN247LCRegistered aircraftN247MSPilatus Aircraft USA Ltd · Broomfield, CON253PCIntermountain Medical Transport LLC · Salt Lake City, UTN25WAir Watkins LLC · Alpharetta, GAN260HSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN263RSNorthern Sky Leasing LLC · Middletown, DEN264WFWilliams Tim DBA · Knoxville, TNN267WFNeljo LLC · Charlottesville, VAN269CTAero27 Tn LLC · Cookeville, TNN269LGCoffin Simon P · RemseckN26KHConcord Jet Service Inc · Concord, CAN271SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2727KRegistered aircraftN273SMGuardian Flight LLC · South Jordan, UTN277PCShc 2021 LLC · Grand Forks, NDN278WCN278wc LLC · Greer, SCN283VCSunridge Aviation LLC · Henderson, NVN284GGtn Aviation LLC · Visalia, CAN285PBBank Of Utah Trustee · Salt Lake City, UTN287PCBank Of Utah Trustee · Salt Lake City, UTN292PSteelman Aviation Inc · Las Vegas, NVN298TTMat Air LLC · Bridgeport, TXN299AMAir Methods LLC · Greenwood Village, CON29BBPc-12 Kwru LLC · Stockton, CAN302PBDoverdel LLC · Bensenville, ILN303JDLisgar II LLC · San Rafael, CAN304PTTrygg Holdings LLC · Anchorage, AKN307WLJk&S Movers LLC · Winter Park, FLN307WPAg Transit LLC · Topeka, KSN311VMGuardian Flight LLC · Lewisville, TX
Back to AD 98-11-01 R2