AD 2016-07-24
Registered aircraft · 4,096
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-07-24')
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-07-24')
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-07-24') 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-07-24') 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.
N144JCJackson Construction Aviation LLC · Quitman, TXN145SWShore Gerry · Inez, TXN145TTVenture Air Solutions Inc · Dallas, GAN146TJBirdboys2 Aviation LLC · Boerne, TXN1491Petecraft Aviation Services Inc · Plains, GAN149AFTitan Group Inc · Tucson, AZN149ARB-Cat Aviation LLC · Tulsa, OKN14BRGobin Albert W · Crawfordsville, INN14JDC340-340 LLC · Pinckney, MIN14MCBlue Skies Blue Water LLC · Henderson, NVN14RTSierra Ae LLC · Wilmington, DEN14UAMilam Equipment LLC · Trussville, ALN1500G5 Lg LLC · Rome, GAN150BGMbw Aviation LLC · Bay City, MIN150CFDesutter S Bryan · Manito, ILN1510GGmr Leasing LLC · Lincoln, DEN1527GHanley Thomas W · Kissimmee, FLN1534GRugger Investment Group LLC · Tustin, CAN153RJones Jeremy R · Lampasas, TXN1543GQds Aviation LLC · Baton Rouge, LAN1549TPalmer Jonathan L · The Woodlands, TXN154TTHotel Sierra Aviation LLC · Texarkana, TXN1554TRegistration Pending · Tampa, FLRegistration pendingN1556TCalifornia Energy Exchange Corp · Rancho Cordova, CAN1557GAirperks LLC · Kalispell, MTN1557TCessna 414 LLC · Lincoln, NEN155DMHarden Aviation LLC · Washington, PAN155JQualitair LLC Trustee · MichelstadtN1563TN1563t LLC · Sheridan, WYN1565TForbes Consolidated Inc · New Smyrna Beach, FLN157CCWhite David W · South Fulton, TNN157SGRichland Aviation Inc · Sidney, MTN1581GKovach Kenneth R · Jefferson, OHN1592GCtl Legacy Holdings LLC · Midland, TXN1596GN1596g Inc · Peachtree City, GAN1596TPlane Crazy Inc · Page, NDN15DSAll Attitude Aviation Inc · Edgewater, FLN15JDSwanson Alec · Hanahan, SCN15SVGore Joshua · Sedro Woolley, WAN15TVDfl Management Corp · New Castle, DEN15VVLiberty Flying Club Inc Trustee · Wilmington, DEN15WMSidhu Teg Singh · Bakersfield, CAN15WRAcmc Operations LLC · Cedar Park, TXN15ZPStefenelli Aviation N Tr Inc Trustee · AtterseeN1600TBpm Rentals Inc · Lincoln, CAN1603TMedcare Emergency Medical Services Inc · Mcallen, TXN160DCPdii LLC · Concord, NCN160PBHyannis Air Service Inc · Hyannis, MAN1616TDavila Alexander · Davie, FLN1618TRandolph James · Greensburg, PA
Back to AD 2016-07-24