AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N6629RDempsey Yvonne Grace · Guys Mills, PAN6629UHanggee Sanford C · Aurora, CON6629WWilcox Chris M · Canajoharie, NYN662APiper Archer Three LLC · Wilmington, DEN662BFFoster Robert B · Erie, PAN662KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN662NDUnd Aerospace Foundation · Grand Forks, NDN662RSBender Jeff L · Canal Winchester, OHN662SPCessna N662sp LLC · Duluth, GAN662TSchoch Michael Pa · Punta Gorda, FLN662TFAir Fleet Holdings LLC · Missoula, MTN66301Guidry David Brian · Lake Charles, LAFirst renewal noticeN6630RGamma2 Inc · San Diego, CAN6630TRoberts Joshua E · Pike Road, ALN6630UBartholow Paul V · Santa Rosa, CAN6630WRiggin Flight Service Inc · Madison, SDN66312Ryther John William · Austin, MNN66313Brazon Brian D · Belle Vernon, PAN6631UMitchell 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, WYN66337Bales Robert · Osage Beach, MON66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedN6633FRegistration Pending · Moses Lake, WARegistration pendingN6633JBailey Randall D · Oakley, MIN6633RBlake 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, SDN66352Seaplane Adventures LLC · Cheyenne, WYN66354Chesson Bradley S · Tacoma, WAN6635BChandler Jerome P · Redondo Beach, CAN6635DGooderum Mark P · Excelsior, MNN6635JIndian Head Flying Club LLC · Indian Head, MDN6635UBistline Ladell J Sr · Colorado City, AZN6636DAnderson James M · Little Rock, ARN6636LAoa Kissimmee Inc · Kissimmee, FLN6636TVincent Air LLC · Carroll, IAN6636UBurcham Jaime S · Advance, NCN66370Dyer Evan H · Ann Arbor, MIN6637JCaison Rodney D · Carrollton, VAN6637RSchawang Darrin E · Falls City, NEN6638BAhmed Gedi A · Saint Paul, MNN6638HWright Aero Inc · Saint Cloud, MN
Back to AD 90-04-06 R1