AD 2018-04-13
Registered aircraft · 1,373
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:2018-04-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:2018-04-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:2018-04-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:2018-04-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.
N330SAThree Feathers Logistics LLC · Atlanta, GAN330ZAMead Gregory Zane · Lubbock, TXN332FXPinto Marc · Cleveland, OHN3337JBig Horns Leasing LLC · Jackson, WYN333KHZzz Aviation LLC · Carlsbad, CAN334AFSusieair LLC · Houston, TXN335AFArcadia Leasing LLC · Arcadia, WIN335FGN335fg LLC · Urbana, ILN335FXFlexjet LLC · Cleveland, OHN335REProampac Logistics LLC · North Hampton, NHN336FXFlexjet LLC · Cleveland, OHN337FXGabbert John · Cleveland, OHN338FXFlexjet LLC · Cleveland, OHN338JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN339BVAljobe Bajeky LLC · Levittown, NYN339CMMmr West LLC · Salem, ORN339FXTj Point LLC · Cleveland, OHN339TBJkdb Air LLC · Beaumont, TXN33CHRitz Air LLC · Dayton, OHN340FXFlexjet LLC · Cleveland, OHN340JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN342FXMansefeldt Investment Corp · Cleveland, OHN343FXFlexjet LLC · Cleveland, OHN343JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN345DXDsg Finance LLC · Coraopolis, PAN345FXFlexjet LLC · Cleveland, OHN345HGAxios Aviation LLC · Traverse City, MIN345WPBank Of Utah Owner Trustee · Salt Lake City, UTN347FZZones Aircraft Leasing LLC · Bellevue, WAN347KKiewit Engineering Group Inc · Omaha, NEN347NAUS Bank Na Trustee · Hartford, CTN348BABillion Air LLC · Sioux Falls, SDN349KKiewit Engineering Group Inc · Omaha, NEN34GWRegistered aircraftN34JMFlying Bullet LLC · Grand Island, NEN350AJCsc Delaware Trust Co Trustee · Wilmington, DEN350ATRmf Horizon LLC · Syracuse, NYN350CKSilver Britches Air LLC · Athens, GAN350HHCsc Delaware Trust Co Trustee · Wilmington, DEN350HJLr60 296 Florida Holdings Inc · Coral Gables, FLN350JRKatz Aviation Holdings LLC · Pompano Beach, FLN350KHAmerican Builders & Contractors Supply Co Inc · Beloit, WIN350KMCarolina Air Transfer II LLC · Alpharetta, GAN350KRMmr West LLC · Salem, ORN350LMBank Of Utah Trustee · Salt Lake City, UTN350LTDohertys Toys Second LLC · Lakeland, FLN350LY350 Lear Yankee Partners LLC · Chesterfield, MON350MBRockwell Collins Leasing LLC · Cedar Rapids, IAN350NPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN350PDBrighid Air LLC · Farmingdale, NY
Back to AD 2018-04-13