AD 99-05-13 R1 WD
Registered aircraft · 13,518
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:99-05-13-R1-WD')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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.
N8122RAviation Buddy Corp · Incline Village, NVN8126NHyder/Zemke LLC · Albuquerque, NMN8127RKanok Enterprises LLC · Derby, KSN8128NCloudstreet Investments LLC · San Antonio, TXN812BGGallo Robert L · Palm Beach Garden, FLN812ELLambard Luke G · Bossier City, LAN812RHeinen Michael J · Mooresville, NCN812WPMerrell Clayton Lee · Amarillo, TXN8130RGaines Robert G · Howell, MIN8131HCataldo Michael · Hingham, MAN8131NArgus Lester M · Margate City, NJN8132NBeechit LLC · Prescott, AZN8133RAero Tex LLC · Jacksonville, FLN8133VN8133v LLC · Greenville, NCN8134RFolsom Airplane Co LLC · Longwood, FLN8135NAlbion Air Enterprises LLC · Albion, NEN8135RKeyt Richard C · Granbury, TXN8136ERunyon Rodney D · Portland, TNN8136RDreamstead Recreational Vehicles LLC · Kalispell, MTN8137PFlying Daze · Batavia, OHN8137RWestdale Aviation LLC · Shreveport, LAN8138RDavenport Clifford M · Bonita, CAN8139RStiller David L · Sedona, AZN813CHBlech Andreas J · Grants Pass, ORN813MMRc Air Ventures LLC · New York, NYN813PJBank Of Utah Trustee · Salt Lake City, UTN8140NViolette James · Glendale, AZN8141YTrifunac Alexander D Trustee · Boulder, CON8142NSmith Dennis A Trustee · Salem, ORN8142WByrne Real Estate Group LLC · Charlotte, NCN8143JFly Girl Aviation LLC · Little Rock, ARN8145RWatch Ya Head Aviation I LLC · Zionsville, INN814DBNorth Rock LLC · Wilmington, DEN814JCSports Medicine Consulting LLC · Midlothian, VAN814JEEasca LLC · Little Rock, ARN814JGKrahulik Jon L · Fredericksburg, TXN814LAAkamo Abiodun T · Line Lexington, PAN814TDWesley Roy W · Carmichael, CAN8152CBonanza52c LLC · Eastsound, WAN8152RElbow Key LLC · Blue Bell, PAN8153GValenzuela Aviation LLC · Little Rock, ARN8154QShine Hugh D · Temple, TXN8155RLarson James R · Waupaca, WIN8158RFullerton Vtail Partners LLC · Mission Viejo, CAN8159RWiencke John K · San Francisco, CAN815BFN815bf LLC · Westlake Village, CAN815JTL G T LLC · Bronwood, GAN815KKBristol Aircraft Leasing LLC · Montgomery, ALN815LAGarrettgobo LLC · Saint Augustine, FLN815QSumo Tails Ltd · Wilmington, DE
Back to AD 99-05-13 R1 WD