AD 91-21-01 R1
Registered aircraft · 5,086
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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.
N713HMPinto Carlos · Tucson, AZN713WTWtw Air LLC · Houston, TXN714KLMatera Management LLC · Spanish Fork, UTN715BBMartin L Jeffrey · Hudson, OHN715LGGuy Transportation Ltd · Carolina, PRN715LMIntepros Inc · Jupiter, FLN7164DAir Arctic Inc · Fairbanks, AKN716PRChupond America Inc · Pittstown, NJN716SBDirect Gulf Access LLC · Springfield, MON716TCCentral Airlines Inc · Leawood, KSN717GMAlbatross Aviation LLC · Tazewell, TNN717MZMaritz Paul · Mercer Island, WAN717SKLava Rock Properties LLC · Saint George, UTN717UOcean Abaco LLC · Virginia Beach, VAN719PFuhr David · Wabasso, MNN71CEMcgowan Chad · Rock Hill, SCN71DPDjp Enterprises Inc · Chandler, TXN71FLWest Transportation LLC · West Bloomfield, MIN71JGFred Garrison Oil Co · Plainview, TXN71WZArlington Aviation Inc Trustee · Wilmington, DEN7204CHousley Communications Inc · San Angelo, TXN720JBSchoettle Steve P · Heber Springs, ARN720KMTrubee Jay G Trustee · Palm Desert, CAN720WDThorntons Aircraft LLC · Tuscaloosa, ALN721CEErtel Thomas H · Charlotte, NCN722AVMcdaniel Ibarra Professional Services Inc · Palm Desert, CAN722CZThree D Adventures LLC · Newfolden, MNN722ETSymonds Stephen M · Colleyville, TXN722LWWineberg Lindsay · Beverly Hills, CAN722RMFisher Mark A · Leola, PAN722TTNext Gen Aviation LLC · Jenks, OKN7234CConfidential LLC · Lutz, FLN723KYCommonwealth Of Kentucky · Frankfort, KYN724ATH Squared Aviation LLC · Sheridan, WYN724WRichard A Klie · Edwardsville, ILN7256DAir Supremacy LLC · Bend, ORN72582Surdex Corp · Chesterfield, MOFirst renewal noticeN7258ZGraber Jesse B · Northfield, MNN7259VKnutson Wayne R · Thompson, NDFirst renewal noticeN725RSHandwerk William C · Georgetown, TXN725TBAircraft Guaranty Corp Trustee · Oklahoma City, OKN72608Gv Air Inc · Medford, ORN7260KAmbitious Aviation LLC · Newport News, VAN72623Law Office Of Vincent G Rieger Pc · Kalispell, MTN7262ACf Aviation Trust LLC Trustee · Wilmington, DEN72634Rnd Technologies LLC · Lancaster, CAN72638Dysart Jack L · Steamboat Springs, CON7264HDelta Sierra Aviation LLC · White Salmon, WAN7265Walker Teresa L · Enid, OKN7265REmerald City Aircraft Leasing Inc · Port Orchard, WA
Back to AD 91-21-01 R1