AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N828AYoder Stephen · Melba, IDN828AKOld City Helicopter Sales LLC · Saint Augustine, FLN828ATSeminole Aircraft LLC · Wilmington, DEN828BCFitzdam Justin D · Franklin, TNN828BLHartt Greg M · Fairfield, CAN828BMChristiansen Aviation LLC · Wilmington, DEN828BNTravelaire Service Inc · Pueblo, CON828CBStokes Robert J Jr · Queen Creek, AZN828CPCivil Air Patrol · Maxwell Afb, ALN828CRRegistration Pending · East Greenwich, RIRegistration pendingN828DMPlane Fun Inc Tr Trustee · Snellville, GAN828EJWhirld Helicopters Inc · Sevierville, TNN828EREmbry Riddle Aeronautical University · Daytona Beach, FLN828FGRidgeline Assets LLC · Wilmington, DEN828FSPerformance Aircraft Sales Inc · Lincoln, NEN828HPParsons Harry · Bloomfield, NJN828HTHappy Trails Aviation LLC · Kalispell, MTN828JMJr Aviation LLC · Tulsa, OKN828JPCarney William F · Gallatin, TNN828JTAtems Elisabeth · Northfield, VTN828LPFlying Twenties Inc · San Jose, CAN828LSKelly Ryan · New York, NYN828LUMuldrow Erik · Newport, KYN828MCHub City Aviation Academy LLC · Lubbock, TXN828PKElizabeth City State University · Elizabeth City, NCN828PLGrosso Michael F · Charleston, SCN828RDCedar Ridge Aviation LLC · Knox City, TXN828RVNewman Charles W · Petaluma, CAN828RWStankie Alexander M · Cocoa Beach, FLN828SGSky High Aviation Of Ga LLC · Doraville, GAN828SPVista Aviation Inc · Pacoima, CAN828TSPlane Fun Inc Tr Trustee · Snellville, GAN828WWMaranatha Insurance Services Inc · Rancho Cucamonga, CAN828YLong Island Aviators LLC · Seaford, NYN82905Reese Melissa A · Soldotna, AKN82907Law Offices Of David Henderson · Anchorage, AKN8290CMckinney Steve R · Hamersville, OHN8290HSchildberg Gregory · Casey, IAN8290JSchaaf Rodney B · Bowman, NDN8290NHorne Larry E · Suffolk, VAN8290PEmge Douglas W · Albertville, ALN8290SNewsome Jeff · Blackwell, OKN8290WCastles James D · Portland, ORN8290XMorrison Preston L · Findlay, OHN82910Great Bay Air LLC · North Hampton, NHN82912Barrows Stuart L · Eagle River, AKN82918Herman Brant · Fairbanks, AKN8291CStober John · Goodrich, NDN8291ERangers Flying Club Inc · Eden Prairie, MNN8291GBullock Brooks M II · Cartersville, GA
Back to AD 81-18-04 R2