AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N4311ALopez Jennifer L · Fort Rucker, ALN4311JWalk Eugene P Jr · Barnegat, NJN4311PRitchie Glenn R · King George, VAN4311QLink John · West Milford, NJN4311TChandler Air Service Inc · Chandler, AZN4311VWayne Braden M · Greenbrier, ARN4311WCarlson Nicholas · Fort Dodge, IAN43120Inge Jame B Jr · Crewe, VAN43124Beale Air Force Base Aero Club · Beale Afb, CAN43125Alpha 1 Aviation LLC · Helena, ALN43126Bdc 43126 LLC · Dumfries, VAN43128United States Air Force Owner · Hanscom Afb, MAN4312FUniversal Aviators Academy Inc · El Monte, CAN4312GGruben Donald C Jr · Rotan, TXN4312RHorizon Group Inc Trustee · Boca Raton, FLN4312TByron James D · Houston, TXN4312VBaron Be 58 LLC · Essex, MTN4312WBreitbarth Brian · Canby, ORN4312YWhittom Ron W Jr · Wasilla, AKN4312ZAlgona Aero Service Inc · Algona, IAN43130University Of Maryland Eastern Shore · Princess Anne, MDN43134Minot Aero Center · Minot, NDN43136Dakota Aviation LLC · Sioux Falls, SDN43138Air-Mods Flight Academy Inc · Robbinsville, NJN4313ARikansrud Eric M · Saint Petersburg, FLN4313DPittsburgh Pilot Training LLC · Bethel Park, PAN4313FJs Partner Consulting LLC · Stamford, CTN4313JPaul Eric S · Diamond Bar, CAN4313NMarco Aviators LLC · Marco Island, FLN4313PBradley Gerald H · Dallas, TXN4313RStauffer Kurt A · Belleville, PAN4313YTracey Robert P · Nondalton, AKN43141Salaues Francisco · Canyon Country, CAN4314BJab Aviation LLC · Houston, TXN4314FAllred Karl T · Evanston, WYN4314JKoch Rodney W · Danville, INN4314PLeverone Joseph P Jr · Minneapolis, MNN4314QRafinski Marcus · San Juan, PRN4314TMcdaniel Jay · Fairborn, OHN4314VHill Thomas M · Circleville, OHN43151Neat Dihedral Aviation LLC · Loveland, CON43154Xavier Rafael O · Dallas, TXN43158N43158 LLC · Bay Shore, NYN43159Peters Pat · Concord, CAN4315COld Salt Aviation LLC · Virginia Beach, VAN4315GWhite Michael · Tenaha, TXN4315NSchrader James A · Marysville, OHN4315QCentral Arkansas Flying Club Inc · Bryant, ARN4315RDuffys Aircraft Sales And Leasng Inc · Neillsville, WIN4315TCommunity Health Alliance · Fairfield, OH
Back to AD 2007-04-19 R1