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.
N99765Tactical Intergriated Training Solutions LLC · Colorado Springs, CON99767Puryear John · Graham, TXN9976DHamon Troy R · King Salmon, AKN99770Civil Air Patrol · Maxwell Afb, ALN9977CSchuster Jacob M · Mchenry, ILN9977DMesserla David M · Manhattan, KSN9977VLunceford James A · Stanchfield, MNN9977WN9977w LLC · Easley, SCN9977YBenninger Timothy A · Cobleskill, NYN99783Alexander Todd · Westhampton, MAN9978RButts James A · Gainesville, GAN9979CVan Lehn Sethany A · Frederick, MDN997ABarlett Jeffrey H · Mentor, OHN997ABBentrup Reinhard F · Goleta, CAN997ACRedemption Air Academy LLC · Huntsville, TXN997CCWunorse Openslae LLC · Dallas, TXN997CWDanesy Dorothea H · Pasadena, CAN997CZClark James S IV · Bristow, VAN997DDark Horse Express LLC · Hendersonville, TNN997FGFlightgest Academy LLC · Morrisville, NCN997GWWoodward Mark J · Bellingham, WAN997HPWard James P · San Jose, CAN997JTRaskin Jamie · Staten Island, NYN997MADodson International Parts Inc · Rantoul, KSN997MCAeroventures Flying Club Inc · Lilburn, GAN997MJNeal Daniel R · Tijeras, NMN997NCVega Gustavo E · Watertown, NYN997RAAtp Aircraft 4 LLC · Wilmington, DEN997SEAero Equities LLC · Ventura, CAN997SGRas Aviation LLC · Elyria, OHN997SUSouthern Utah University · Cedar City, UTN997UPPotti Noah · Kalispell, MTN997VBBrandon Greg V · Georgetown, TXN997WTRxy LLC · Gilbert, AZN9980WAll American Aviation Services Inc · Fayetteville, NCN9981RMatthias Robert C · Gainesville, FLN9981UExpedition Air LLC · Antioch, CAN9981VWeeks Richard F Jr · Portsmouth, NHFirst renewal noticeN99826Cp Aviation · Santa Paula, CAN99832Watch Ya Head Aviation 1 LLC · Zionsville, INN9983PTaf Aerial Services LLC · Beeville, TXN9983VHeyman William L · Santa Fe, NMN9984CTucker Harry B · Lexington, NCN9984RMoloney Phillip M · Lexington, KYN9984VValley Drug Of Malta Inc · Malta, MTN9984WBlake David R · Sheridan, WYN9985BJacks Charles D · Morse, LAN9985DTrimmer Marvin E · Willow, AKN9986CLawrence Oakes K III · Newfields, NHN9986DWalsh Arthur B · Lincoln, NERegistration revoked
Back to AD 87-10-06 R1