AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N840ABDiamond Group Holdings LLC · Greenville, NCN840CSMiller Ashley M · Lima, OHN840DWKoesy Gregory W · Pembroke Pines, FLN840LPMys Aviation LLC · Rockford, ILN840TCNorth Star Aviation Inc · Mankato, MNN840UBoard Of Regents Of The University Of Oklahoma · Norman, OKN840WMKunzelmann Christopher E · Weatogue, CTN84104Morris Daniel B · Ankeny, IAN84105Jost Jared D · Hillsboro, KSN84108Bramblett John S · Russellville, ARN84109Bielak Donald · Louisburg, KSN8410CLevel Up Aviation LLC · Newton, ALN8410ETito Hector · Fayetteville, GAN8410LVictory Lane Aviation LLC · Concord, NCN8410SNorth Shelby Aviation LLC · Wilmington, DEN8410WRenegade6 Aviation LLC · Woodbridge, VAN84114Miami Seaplane Tours Inc · Miami, FLN84117Mendez Arturo · Addison, ILN8411BGrohs Dihl J · Wessington Springs, SDN8411CRtb Aviation LLC · Jurupa Valley, CAN8411DElliott Frank F · Mojave, CAN8411REleven Romeo LLC · Golden, CON8411WHiggins Timothy Owen · Axtell, TXN84122Millican Marc J · Anchorage, AKN84125Koenig Aircraft Restoration Inc · Loranger, LAN84129Petschow Kenneth W · Upland, CAN8412CEiler Marc · Seattle, WAN8412LAddison Flying LLC · Addison, NYN8412PCoastal Air LLC · Naknek, AKN8412RChamberlain Richard T · Collinsville, ILN8412WSutton Timothy A · Glencoe, ALN8412ZVan Deman Frank L · Virginia Beach, VAN84130Gutierrez Sergio E · Pharr, TXN84133Registration Pending · Bowman, NDRegistration pendingN8413CBrown Lawrence L · Millington, TNN8413LRussell Adam G · Easton, MEN8413RZuniga Hector Javier · Mission, TXN8413WHollier Gregory J · Arnaudville, LAN8413YReinbold Frederick K · Anchorage, AKN84140Kaiser Joe E · Anchorage, AKN84141Registration Pending · Mansfield, OHRegistration pendingN84143Jones Donald T · Barrigada, GUN84146Stone Air LLC · Carrollton, GAN84147Cox James O II · Shady Shores, TXN8414CInternational Flying Club Inc · Winfield, ILN8414FPenley Robert G · Corinth, TXN8414LMorris Christopher J · Manor, TXN8414M8414m LLC · Nunica, MIN8414NAirlake Aero Inc · Lakeville, MNN8414RVick Justin M · Morton Grove, IL
Back to AD 87-10-06 R1