AD 2016-26-08
Registered aircraft · 1,377
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:2016-26-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-26-08')
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:2016-26-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-26-08') 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.
N124RCutter Flight Management Inc · Albuquerque, NMN124UVGuardian Flight LLC · Lewisville, TXN125BWBw Air LLC · Houston, TXN125PZStraight Flight Nevada Commercial Leasing LLC · Sparks, NVN126ALShort Hop LLC · Bellevue, WAN126TSLife Flight Network LLC · Aurora, ORN1273ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN127TWTw Leasing LLC · Oxford, CTN129JWAir Methods LLC · Greenwood Village, CON129PKDashiell Corp · Houston, TXN129TPHljh LLC · Corpus Christi, TXN12ARMermerus LLC · Branford, CTN12DHClear Skies LLC · Lafayette, LAN12DZJmp Aircraft Service LLC Trustee · Wasilla, AKN12FAWilke Aviation Group LLC · College Station, TXN12JDYellow Transportation Services Inc · Milwaukee, WIFirst renewal noticeN12NFNiemann Aviation LLC · Quincy, ILN12NVAir Ally LLC · Chisago City, MNN12XFlying Goose LLC · Kennesaw, GAN12XNJdr Aircraft Company LLC · Tampa, FLN131AFManufacturers And Traders Trust Co · Portsmouth, NHN132ASFlight Level Services LLC · Danville, KYN132TPNational Eagle Aviation LLC · Grand Prairie, TXN133PEEpps Air Service LLC · Atlanta, GAN134PFPeco Foods Inc · Tuscaloosa, ALN134TWSrb Aviation LLC · Delmar, NYN135PFPeco Foods Inc · Tuscaloosa, ALN138PSEncore Asset Mgmt LLC · Newton, ILN138TTTtd Travel LLC · Terre Haute, INN13PJcngx LLC · New York, NYN13UARegistered aircraftN142LTJk Aviation LLC · Manteca, CAN146PCLmco · Vandenberg Afb, CAFirst renewal noticeN1471RLendingclub Bank Na · Boston, MAN1477PWestern Aircraft Inc · Boise, IDN147AFShields Corp · Portsmouth, NHN148CA&R Investment Property LLC · Albuquerque, NMN149DLHls Air Inc · Poway, CAN149GTTenmile1 LLC · Rochester, MNN149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PAN14RDLiftwing Aircraft Holdings LLC · Bellevue, WAN151MVDkj Services LLC · Augusta, KSN153LGRw Charter Services LLC · Hopkinsville, KYN153PBCarojake LLC · Spartanburg, SCN153XAllred Leasing LLC · Missoula, MTN156SAStandard Aviation LLC · Memphis, TNN156SBSpark Aviation LLC · West Harrison, NYN156WLCl 245 Partners LLC · Erie, COFirst renewal noticeN158CCutter Flight Management Inc · Albuquerque, NMN1600WFlattop Aviation LLC · San Francisco, CA
Back to AD 2016-26-08