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.
N642SFCoastal Recovery LLC · Fort Lauderdale, FLN643PCRegistered aircraftN644SDSierra Delta LLC · Lititz, PAN645PCValiair Limited Co Trustee · Casper, WYN646VLRegistration Pending · Emerald Hills, CARegistration pendingN649PBoutique Air Inc · Dallas, TXN650BGP & M Aero LLC · Belle Chasse, LAN650LLLikover Larry L · Houston, TXN650MCN650mc LLC · Bountiful, UTN651PBJm Aviation LLC · Ocala, FLN652CRCritical Craft Technologies LLC · Charlotte Hall, MDN658PCAir Methods LLC · Greenwood Village, CON65AFAngel Fire Express II LLC · Southlake, TXN661SAPrometheus Air LLC · Middletown, DEN665MCGrindstaff Aviation Company LLC · Crossville, TNN667RBLaboratory Corp Of America Holdings · Burlington, NCN668TWPanorama Aero 1 LLC · Highland Beach, FLN670WHHelimax Aviation LLC · Howell, MIN671PCAir Methods LLC · Greenwood Village, CON672PBJohnson River LLC · Durant, OKN672SDSweet Darling Sales Inc · Aptos, CAN673PCGarden St Aviation LLC · Fort Myers, FLN675CFRke Log LLC · Baytown, TXN676PCWeeks Kermit A Trustee · Polk City, FLN677STLaboratory Corporation Of America Holdings · Burlington, NCN678RHHeadrick Properties Inc · Laurel, MSN680STHaushalter Nikki · Huntsville, OHN682PCFalcon Aviation LLC · Sikeston, MON684AK84 Alpha Kilo LLC · Sheridan, WYN695PCDaetwyler Aircraft LLC · Charlotte, NCN6FZZebra Air Adventures LLC · Atlanta, GAN701CFLegacy Air 01 LLC · Grand Forks, NDN702JRInterstate Aviation LLC · Las Vegas, NVN705KCAir Methods LLC · Greenwood Village, CON711JCFlby LLC · Spring, TXN714WVPeasant Air LLC · Middletown, DEN715HLIliamna Air Taxi Inc · Iliamna, AKN715NLTnh Leasing LLC · Iliamna, AKN715SJTnh Leasing LLC · Iliamna, AKN715TLTnh Leasing LLC · Iliamna, AKN71TPNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTN723KPKalinin Partners LLC · Juneau, AKN724HFAir Methods LLC · Greenwood Village, CON724KPKalinin Partners LLC · Juneau, AKN725KPKalinin Partners LLC · Juneau, AKN726KPKalinin Partners LLC · Juneau, AKN728MGKnot Crazy Horse LLC · Thonotosassa, FLN72AZBank Of Utah Trustee · Salt Lake City, UTN732SBAero Shares LLC · Excelsior, MNN755EMSea Star Inc · Wetumpka, AL
Back to AD 98-11-01 R2