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.
N6628PRavich Vladimir · Fort Montgomery, NYN6628RD & K Aero · Elkhart, INN6628WFigueroa Ruben E · Las Vegas, NVN6629FCloud10 Aviators LLC · Benton, LAN6629PCrouse William F · Priest River, IDN6629RDempsey Yvonne Grace · Guys Mills, PAN6629UHanggee Sanford C · Aurora, CON6629WWilcox Chris M · Canajoharie, NYN662APiper Archer Three LLC · Wilmington, DEN662BFFoster Robert B · Erie, PAN662CWPrecision Air Inc · Anchorage, AKN662EZRegistered aircraftN662FLane Bruce · Midlothian, VAN662GSouthwest Property Exchange LLC · Cedar City, UTN662KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN662NDUnd Aerospace Foundation · Grand Forks, NDN662RKlotz Douglas · Incline Village, NVN662RFJdm Aero LLC · Pearland, TXN662RSBender Jeff L · Canal Winchester, OHN662SPCessna N662sp LLC · Duluth, GAN662TSchoch Michael Pa · Punta Gorda, FLN662TFAir Fleet Holdings LLC · Missoula, MTN662TMUpright Corp · Kentfield, CAN662WPHolt Gary L · Ventura, CAN6630AIndigo Associates Ltd · Las Vegas, NVN6630PSumners Toby · Aurora, MON6630RGamma2 Inc · San Diego, CAN6630UBartholow Paul V · Santa Rosa, CAN6630WRiggin Flight Service Inc · Madison, SDN66313Brazon Brian D · Belle Vernon, PAN6631FYah Inc · Wilmington, DEN6631UMitchell Caleb C · Hebron, NEN6631WRegistration Pending · Arbela, MORegistration pendingN6631ZClark Ryan D · Sequim, WAN6632GGrayson Robert E · Great Falls, MTN6632JSo Cal Leasing LLC · El Cajon, CAN6632LSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6632ZFranconia Soaring Association · Franconia, NHN66337Bales Robert · Osage Beach, MON66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedN6633FRegistration Pending · Moses Lake, WARegistration pendingN6633JBailey Randall D · Oakley, MIN6633PSkinner Norman D · Osceola, IAN6633RBlake Anthony B · Hallsville, TXN6633WSyf LLC · Okmulgee, OKN66340Wickline Wayne · Flower Mound, TXN66344Sallee Philip L · Yucca Valley, CAN6634BAri Ben Aviator Inc · Fort Pierce, FLN6634JMaier Robert B · Duncanville, TXN6634UC A F E Aviation LLC · Gregory, SD
Back to AD 87-10-06 R1