AD 2005-12-13
Registered aircraft · 479
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:2005-12-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-12-13')
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:2005-12-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-12-13') 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.
N414SMSwair LLC · Cheyenne, WYN414SPDiamond Upgrades LLC · Phoenix, AZN414TAJerry L Stephens Investments LLC · Sunset, SCN414TDAtlas Aviation LLC · Maple Grove, MNN414TFBlue Sky Aviation LLC · Columbia, TNN414TJLobair LLC · Peoria, ILN414UMSouthwest Management Group Inc · Farmington, NMN414VA7210 Charlie LLC · Atlanta, GAN414VBBank Of Utah Trustee · Salt Lake City, UTN414WEN414we LLC · Valrico, FLN414WJCenturion Flight Services Inc · Palo Alto, CAN414WKValiair Ltd Co Trustee · Casper, WYN414WRMoreno Leon Bernardo Eucario · Missouri City, TXN414WSWessex Airlines LLC · Boca Raton, FLN414WTMr Boo Properties LLC · Indianapolis, INN414WYJrh Operations LLC · Canyon, TXN414XXMcnally Operations LLC · Norfolk, NEN414YHVictory Maximus II LLC · Dublin, OHN414ZHynes Kevin P · Branson, MON416RARegistration Pending · Muskegon, MIRegistration pendingN426LJVenture Air Solutions Inc · Opa Locka, FLN4272CKamps Air LLC · Grand Rapids, MIN429RCN429rc LLC · Gladwyne, PAN42AAN42aa LLC · Nantucket, MAN42MGSouth Aero Inc · Albuquerque, NMN42MWWalker Winston W Trustee · Tucson, AZN43MRFlight Contract Services Inc · Las Vegas, NVN441TPUnited Contractors Inc · Costa Mesa, CAN441TTSunbird Airlines Inc · San Juan, PRN442CCRaymond Andrew A · Crescent, IAN442FMHogan Quinn H Trustee · Milwaukee, WIN44GAFly Qts LLC · Oconomowoc, WIN454SPSps Investment Properties LLC · Macon, GAN4630NHyannis Air Service Inc · Hyannis, MAN4666NM & P Genpar LLC · Corpus Christi, TXN4668NSre Holdings LLC · Dewitt, MIFirst renewal noticeN466CAHyannis Air Service Inc DBA · Hyannis, MAN4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNN4680NRentz Communications Inc · New Smyrna Beach, FLN4693NWade Air LLC · West Palm Beach, FLN4698AExpress Air LLC · Wilmington, DEN4701AWtfa LLC · Decatur, ALN471MASwift Aviation LLC · Decatur, TNN4772ADodson International Parts Inc · Rantoul, KSN477RSSundbird Airlines Inc · San Juan, PRN4837ALongleaf Wing Ventures LLC · Birmingham, ALN484SWElsass Aviation LLC · Fayetteville, ARN48AMGwc Air LLC · Madison, ALN494BCHyannis Air Service Inc · Hyannis, MAN495495htsi LLC · Wilmington, DE
Back to AD 2005-12-13