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.
N6840NJohnston Robert M · Plantation, FLN6841LSaglimbene Ronald · Wyckoff, NJN6841MGwiazdon Edward P · Lake Elmo, MNN6841WBoehm Darrell · Safford, AZN6842JOracle Aviation LLC · Omaha, NEN6842UThompson Matthew S · Fowler, CON6843HWhitefish Mountain Acft Rentals And Flt School LLC · Whitefish, MTN6843UBoone Joe · Madison, INN6843WRhodes Michael J · Fresno, CAN6843YBarlam Theodore P · Poway, CAN6844JHundshamer Sara M · Smithfield, UTN6844ZAntelope Valley Soaring Club · Llano, CAN6845BShrode Rafe C · Jewett, TXN6845NTriplett Jared · Mckinnon, WYN6845UTarrant James D · Wenatchee, WAN6845ZBr Trucking LLC · Cut Bank, MTN68460Registration Pending · Sheridan, WYRegistration pendingN6846NBitcertificates LLC · Kalispell, MTN6846UStokely Nicholas J · Wagram, NCN6847BOtt Grosvenor LLC · Dillingham, AKN6847DPietron Spraying Inc · Larimore, NDN6847JMarkle Rick S · Waddy, KYN6847UFolkerts Thomas A · Roseville, CAN6848BPainter William L · Salem, VAN6848JPrudent Paths LLC · Hillsborough, CAN6848NWinner William B · Durango, CON6848UKiefer Nathaniel Stephen · Del Rio, TXN68499Sheboygan Survey LLC · Waldo, WIN6849BWeeks Vaughan B · Racine, WIN6849JSecker David A · San Jose, CAFirst renewal noticeN6849NBig Bad Technology LLC · Hawthorne, FLN6849PSvenningsen Joshua J · Menomonie, WIN6849UShipman Terry · Flossmoor, ILN684APiper Archer Three LLC · Wilmington, DEN684ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN684DWSun Aircraft Management LLC · Ormond Beach, FLN684FLRegistration Pending · Odenton, MDRegistration pendingN684LHChristiansen Aviation LLC · Wilmington, DEN684NDUnd Aerospace Foundation · Grand Forks, NDN684RAArendale Richard O · Hattiesburg, MSN684RWWarren Randal W · Pine Bluff, ARN684SPCondor Aero Club Inc · Zelienople, PAN684TCPixel King 03 LLC · Fort Worth, TXN68500Air Dakota Flite Inc · Hettinger, NDN68504US Liberty Holdings LLC · Caldwell, IDN68505Volara Aviation LLC · Glendale, AZN68508Williams Houston · Minot, NDN6850ULarson Steven H · Angel Fire, NMN6850WDixon Holly R · Denton, NEN6850ZWagner Construction Inc · Intl Falls, MN
Back to AD 87-10-06 R1