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.
N8155GSaraceno Robert Jr · Lynnfield, MAN8155HPeckerhead Motorcycle Racing LLC · Gainesville, GAN8155NThompson Trent A · Forsyth, MTN8155PSanders Tyler George · Tehachapi, CAN8155WCochran William J · Williamson, GAN8156DMoyle Matthew L · Soldotna, AKN8156NMoreau Donald G · Dayton, TXN8156PVectors West LLC · Coeur D Alene, IDN8156RGhazarian Christopher L · North Hollywood, CAN8156TAzcona Rogelio G · Okeechobee, FLN8156WLandis Michael D · Jonestown, PAN81573Jsham LLC · Sheridan, WYN8157CAfshar George · Trabuco Canyon, CAN8157MSpecialty Veterinary Services LLC · Monteverde, FLN8157NBolton Jeffrey · Mont Belvieu, TXN8157WFippin Brett Thomas · Brentwood, CAN8157YSchmidt Zachary P · Raleigh, NCN81586Elbarki Maged A · Boca Raton, FLN8158BRegistration Pending · Springfield, MORegistration pendingN8158DBates James H · Lakeview, ORN8158NHorizon Aviation LLC · Brooks, GAN8158WMills Jeroldine C · Altaville, CAN8158YRobert Lea Investments LLC · Molalla, ORN8158ZLee Randy A · Gulf Shores, ALN81593Krueger Carl M · Kelleys Island, OHN815975 Niner 7 LLC · Fort Lauderdale, FLN8159AN8159a LLC · Jupiter, FLN8159KQ G Aviation Of America Inc · Fort Collins, CON8159PRegistration Pending · Tucson, AZRegistration pendingN8159SGaither David G Executor · Houston, TXN8159WDowner Jesse S · Acampo, CAN8159YRaven Aviation LLC · Murrayville, GAN815CHawaii Soaring LLC · Kailua, HIN815CPCivil Air Patrol · Maxwell Afb, ALN815DFOglesby Richard A Jr · Atlanta, GAN815DKBas Part Sales LLC · Greeley, CON815DZBlue Sky LLC · Overland Park, KSN815EHBuell Travis · Harper, TXN815JHHeligroup LLC · Wilmington, DEN815JMMaling Jeff · Afton, WYN815KSPenner Bruce Wade · Hot Springs, SDN815KTFrase Kenneth E · Fall Creek, WIN815PTTestory Perry E · Urbana, ILN815SGGierisch Frederick · Utopia, TXN815TAS3 Air Aviation LLC · Henderson, NVN815VPBarrett Jeff K · Pollock, LAN8160AKasw Aviation LLC · Warsaw, INN8160HRegistered aircraftN8160PSouth Texas Weather Modification Association · Pleasanton, TXN8160QAbaco Express Logistics LLC · Orlando, FL
Back to AD 87-10-06 R1