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.
N4372APex John A · Chugiak, AKN4372BTyler Hendry Dds Inc · Glendale, CAN4372EPad Aviation LLC · New Castle, DEN4372LSteen Douglas S · Cresson, TXN4372RKennemer Farms Inc · Carter, OKN4372SBelser Mark · Avon, OHN4372XMurphy W Gary · Manitou, KYN43731Bondy Drew · Farmington, MNN4373JMiller Lillian N · Conyngham, PAN4373PMartin Vernon W · Peoria Heights, ILN4373RKlc Associates · Unionville, CTN4373TMichelli Charles Wayne · Kingsport, TNN4373WDreamline Aviation LLC · Saint Petersburg, FLN43742Hesston College · Hesston, KSN43745Coyle Andrew J · Pierre, SDN4374HAlexander Chang Lee · Menifee, CAN4374MThursby William T · Cedar Hill, TXN4374NPalmet Luis A Alonso · Homestead, FLN4374PDodson International Parts Inc · Rantoul, KSN4374QWillaero LLC · Union City, TNN4374UN4374u LLC · Dover, DEN4374XBiggles Aviation LLC · Endicott, NYN4374ZLasseter Granville D II · Richmond, TXN43751Casey Brian · Hawley, PAN43753Glacier View Aviation LLC · Kalispell, MTN43755Mang Aero Club Inc · Belleville, MIN43756Acme Aviation LLC · North Beach, MDN43758Fleckenstein Jacob L · Decatur, TXN4375BDewilde Lee R · Huslia, AKN4375FWings Aero LLC · Zeeland, MIN4375JSpring George B · Chester, CTN4375PShea Roger · Alta, WYN4375TPillar Paul S · Lancaster, OHN4375WTouch N Go Aeroworks LLC · Greenville, SCN4375ZRwr Air Inc · Tok, AKN43765Mcdonald Christopher Ryan · Bridgeport, TXN4376APeavy Ricky Tod · Gainesville, GAN4376GColeman Tennie J · Dennistown, MEN4376HCharlevoix Flying Club Inc · Petoskey, MIN4376JBlunt Jesse R · Winfield, MON4376QFranke Russel G · Silt, CON4376RMoore Michael J · Mountain Brk, ALN4376SDubyk Nickoli · Stafford, VAN4376TZara Aviation Corp · Chatsworth, CAN4376WSmith Ryan · Canby, ORN4376ZLabbee Tyler J · White Swan, WAN43770White County Flying Club Inc · Fairfield, ILN43774Freeman James A III · Columbus, OHN43779Chandler Air Service Inc · Chandler, AZN4377ATebeaux William Jene · College Station, TX
Back to AD 2007-04-19 R1