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.
N2888QChilds William C · Bridgeport, ALN2888TValenstein Glenn L · Howards Grove, WIN28890Slocum Chad W · Pleasant Grove, UTN28893Janzen Andrew S · Oklahoma City, OKN28896Pafford David A · Floydada, TXN2889EWesellhigh LLC · West End, NCN2889FLander Kirt E · Kingman, AZN2889RAircraft Structural Repair Inc · Hamilton, MTN2889TRegistered aircraftN2889XKogele Donald J · Broadus, MTN2889YJust Jump Skydiving LLC · Laurens, NYN2889ZPeters Thomas K · Wasilla, AKN288ABSyrasoft Aviation LLC · Baldwinsville, NYN288AWRegistered aircraftN288BCInnovations Educational Consulting Inc · Eden, UTN288BDHop Props LLC · Houston, TXN288BLBlue Line Aviation LLC · Smithfield, NCN288BTValiair Ltd Co Trustee · Casper, WYN288CBCalifornia Baptist University · Riverside, CAN288CDKrempp Michael E · Arlington, TXN288CFAdams Charles R · Granbury, TXN288CPCivil Air Patrol · Maxwell Afb, ALN288DCFoltz A Wendell · Mcminnville, ORN288FGroove LLC · Afton, VAN288FDFly Dynasty Corp · Ocala, FLN288GHBowen Christina M · Shreveport, LAN288HCLampe Erik J · Appleton, WIN288HGGeorgia Aviation Authority · Eastman, GAN288HPChaikin Steven · Kaunakakai, HIN288KDavison Pere · Cody, WYN288LSVacendak William A · Wasilla, AKN288LTGlatczak Jerome · Schofield, WIN288MTgc Aviation LLC · Watkinsville, GAN288MCTomanec Jean · Victoria, TXN288MDDietl Manfred · Naples, FLN288MESouth Dakota State University · Brookings, SDN288PBlue Water Aviation Inc · Jupiter, FLN288PASkywest Leasing Inc · St George, UTN288RAntes James H · Northfield, MAN288RTSavonen Stephen D · Ukiah, CAN288RVBarrientos Jeri D · Collinsville, OKN288RZBkjm LLC · Blanchard, OKN288SCDelta Aviation LLC · Oregon City, ORN288SPGlass Cockpit Aviation Inc · San Juan, PRN288STRegistered aircraftN288SVMartin Terry L II · De Soto, MON288TATurbine Time LLC · Mercer Island, WAN288TBCejka Robert K · Cudahy, CAN288TMSlaba Mark E · Arcadia, FLN288TWWaterwings Seaplanes LLC · Hoover, AL
Back to AD 2007-04-19 R1