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.
N9598JMardis Andrew · Pelzer, SCN9598MBergland John Edward · Santa Monica, CAN9598UJackler Leon J · Silver Spring, MDN9598ZDel Valle Enterprises Inc · Sandpoint, IDN9599CDomenico Joseph A · Saint Germain, WIN9599JOrban Kenneth D · Tellico Plains, TNN9599KRed Wing Soaring Association · Osceola, WIN9599WNelson Scott G · Lakota, NDN9599ZBorn John G · Jupiter, FLN959AANorth Wheeler O · Carlsbad, CAN959AGGrant Altin C · Tahlequah, OKN959BWRegistered aircraftN959CVaero Inc · Vinton, VAN959DBSigma Pharmaceuticals LLC · Monticello, IAN959ERs Specialties LLC · Anchorage, AKN959EDDoering Eric A · Litchfield, MNN959GAtp Aircraft 9 LLC · Wilmington, DEN959HCNorthwest Wings LLC · Hillsboro, ORN959MMBugle Equipment And Leasing LLC · Houston, TXN959PDMilligan Thomas A · Dana, INN959RDDoering Ray A · Devils Tower, WYN959RMLargent Richard B · Southport, NCN959RVRegistered aircraftN959TELawless John M Jr · Tucson, AZN959TTVan Bortel Aircraft Inc · Arlington, TXN95AACoolidge Marvin L · Newberg, ORN95AGSale Reported · Montgomery, ALSale reportedN95AHBrown Hunter · Sulphur Rock, ARN95APWingnut Enterprises Inc · Sarasota, FLN95AWScotts Air LLC · Prescott, AZN95BEAmundson David Owen · Sioux Falls, SDN95BNMcphillips Flying Service Inc · Charlevoix, MIN95BRChickasha Wings Inc · Chickasha, OKN95CHJones Cecil W · Fort Walton Beach, FLN95CJSimmons Marshall · San Antonio, TXN95CPGates Thomas S · Moyock, NCN95DHHooker Douglas L · Spring Branch, TXN95DJSanders Aviation Inc · Jasper, ALN95DLOwen Jayson S · Tampa, FLN95DRRoss Dan G · Newcastle, CAN95EDHaven Steven D Jr · Capac, MIN95EGNelson Gregory E · Austin, TXN95EPFlying Cow LLC · Falls City, NEN95FDLowrey Jonathan S · Jasper, INN95FHFlying Hawkes LLC · Hamilton, MTN95FSN95fs Ltd · Chicago, ILN95GWSkypirate Aviation LLC · Staunton, VAN95HCCrosswell Joe · Springtown, TXN95HDGreffenius Brian J · Covington, LAN95HFEddings Samuel David · Camino, CA
Back to AD 87-10-06 R1