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.
N8040PSutton Thomas C · Corning, NYN8040WJeff Abrams-2 LLC · Ocala, FLN80414Garn Darrell L · Palmetto, GAN80419Korona Lawrence K · West Paterson, NJN8041BIchtou LLC · Dover, DEN8041HKing Ag Leasing Inc · Sudan, TXN8041MLewis Edward H · Moorestown, NJN8041PEnsign James P · N Richlnd Hls, TXN8041WBas Part Sales LLC · Greeley, CON80421Kuder Kyp E · Rogers, NDN80424Johnston Robert K · Sylvania, GAN80425Fellows Roy H · Augusta, KSN80426Pcb Aviation LLC · Davidson, NCN8042BSummerskyz Inc · Saint Joseph, ILN8042DYounger Tyler J · Bakersfield, CAN8042FFlying Hawks Inc · Palmyra, WIN8042GTemple In The Sky LLC · Marietta, GAN80434King William Daniel · Southlake, TXN80436N80436 LLC · Columbia, MSN80439Oklahoma State University · Stillwater, OKN8043JHartland Helicopters LLC · Edinburg, TXN8043PGray Motors Inc · Port Angeles, WAN8043RPat Brown Aviation LLC · Dodge Center, MNN8043UClassic Banjo LLC · Richmond, KYN8043WMcabee Aviation LLC · Fresno, CAN8043YN56453 LLC · Bowie, MDN80440Rockey John · Jupiter, FLN80441Archer Aircraft LLC · Wilmington, DEN80442Washburne Seth P · Dallas, TXN8044DGillen Sean P · Arlington, TXN8044LOverton Larry D · Hermiston, ORN8044NN7396w LLC · Coeymans Hollow, NYN8044RCobb Gerald E · Jacksonville, FLN8044TArcher Aircraft LLC · Wilmington, DEN8044WKananen Agency Inc · Joliet, MTN80454Tadao LLC · Tucson, AZN80456Barash Geva S · Ashland, MAN80458Kolpack Glenn H · Sonora, CAN8045DLarson Larry E · Twin Valley, MNN8045KEmerald City Aircraft Leasing Inc · Port Orchard, WAN8045NCti Aircraft Leasing LLC · Memphis, TNN8045PDuncan Mark L · Hyampom, CAN8045RCcf Ventures Inc · Bangor, MEN8045SHenry Mark A · Dickinson, TXN8045WOpen Engineering LLC · Ames, IAN80469Hetherly Bryce D · Clintondale, NYN8046RComputer Solutions Inc · Casper, WYN8046WMuthandi John M · Woodland, WAN80470Coddiwomple LLC · Newberg, ORN80471Dairy Air Inc · Wyoming, PA
Back to AD 87-10-06 R1